Hi,
What is the MySQL statement to do a free text search in a field.
e.g. look for all the entry that contain the word ’zoom’, while the data in the field may be like that ’zoomX8, macro, flash’.
Thanks.
look up the "LIKE" function in your SQL reference. It's used for finding text in text fields.
You'll need to use wildcards on either side of the word, and also handle whether the upper/lowercase situation.
...WHERE TO_UPPER(textfield) LIKE '%ZOOM%"
