Search Script

[brendan2b]

I have been reading a lot of posts on these forums and it appears that the most basic MySQL search technique happens to be

$search = mysql_query("SELECT * FROM `table` WHERE `fieldName` LIKE'%$criteria%'");

Now is there a way to search the whole table for your search term instead of an individual field, or would I have to do multiple queries?

Also, what are some other techniques for more complex searching scripts. I know a lot of string functions and can pretty much figure out most anything over time, so does anybody have any links or ideas to point me in the right direction. Thanks.

[dagon]

that does search every 'fieldName' in your 'table'

for more complex mysql searching see: 2.7. Full-Text Search Functions

[brendan2b]

Hey thanks a lot dagon.

[bradgrafelman]

brendan2b wrote:

Now is there a way to search the whole table for your search term instead of an individual field, or would I have to do multiple queries?

Not multiple queries, but multiple WHERE statements:

SELECT `column1`, `column2` FROM `myTable` WHERE `field1` LIKE '%criteria%' OR `field2` LIKE '%criteria%' OR `field3' ...

Also note that "SELECT *" most often wastes resources - only select the columns that you're going to need.