Search Criteria based on more than one word

[macnimation]

Hi,
I have created a Search Input that when a word is typed, I get a result of records based on all or part of the word, which is fine, and this is based across several Fields.

Any Table fields that contain all or part of the word displays the record.

SELECT *
FROM tbmain
WHERE Owner LIKE %SearchString% OR Status LIKE %SearchString% OR TaskSummary LIKE %SearchString%  OR TaskDescription LIKE %SearchString% OR Type LIKE %SearchString% OR ValueAdd LIKE %SearchString%
ORDER BY Owner DESC

This was fine, but now there are about 500 records in the MYSQL Database, so I need to refine the search by being able to add more than one word, and only display records that contain BOTH words, across all of the above fields, and not records that contain either or, if this makes sense?

I tried replacing OR with AND, but I still get the same result

If you need any further information please let me know.

Cheers

[mwasif]

Hi macnimation,
Welcome to TSDN!!!

Checkout MySQL FULLTEXT search in BOOLEAN MODE.

[macnimation]

Thanks for the help, I'm trawling my way through the link.