[thegermster]

Hey guys,

I wish to know how to do a simple MySQL search. I want to search through many fields that I have in one table. I looked at some documentation and came across the MATCH() AGAINST() command. I tried a few different scripts on my own, but came out with errors.

Here's what I tried:

Code:

$query = "SELECT * FROM tableName WHERE MATCH (fieldName) AGAINST ('wordToSearchFor');

I've never used the search feature before so this might be waaaay off. Can anyone tell me the correct command for this?
Thanks!