free text search in a field.

[dkin]

Hi,

What is the MySQL statement to do a free text search in a field.

e.g. look for all the entries that contain the word ’zoom’, while the data in the field may be like that ’zoomX8, macro, flash’.

Thanks.

 

[sleipnir214]

WHERE columname like '%zoom%'

or

WHERE columnname regexp 'zoom' Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!