In a table, a single field contains a definition of a word, with each definition seperated by ;
So when a search is done against the field to find a pattern, is there a way to tell mysql to break the field apart by ';' and search each item from it seperatly instead of the field as a whole?
So when a search is done against the field to find a pattern, is there a way to tell mysql to break the field apart by ';' and search each item from it seperatly instead of the field as a whole?