Hi, I have a script that searches on 1 field and I would like to make it searching for 10 fields but with this way:

field1 like $var1 AND field2 like $var2 etc...

I mean that I don't want it to search ALL variables at ALL fields with AND but each variable at one field.

Could someone please help me with an example?
If possible I would also like an example on how to add fields to SQL.

Thanks in advance.

hi

SELECT * FROM table WHERE MATCH(field1,field2,....) AGAINST('keyword')

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com