Jump to content

Searching A Database


phrozenfire

Recommended Posts

Hi guys,

Heres the situation, my client wants a search facility on the site. I can do this OK, but the problem that I am finding is that as I am searching a database, I have to type every single field in.

eg "SELECT * FROM table WHERE name LIKE '%$search%' OR comment LIKE '%$search%'";

However, there are 25 fields on this table, and many more thousands on the other tables, so is it possible to search a row rather than a specific column?

Thanks in advance
Link to comment
https://forums.phpfreaks.com/topic/35431-searching-a-database/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.