I've done a mySQL search using SELECT and WHERE but it only finds exact matches. How can I find a delimiter in a text field so if the word 'frog' was somewhere in it it would return that row?
Read the MySQL manual about the LIKE statement and about FULLTEXT indexes.
So if I want to use FULLTEXT search I have to alter my table to have a FULLTEXT index and then I can use the MATCH function?
Correct.
It works!!
Good work!
