I have a string matching question that is beyond my knowledge when it comes to regex in mysql.
I have a rather large table with csv fields that needs to be searched and I need to be able to match rows according to 1+ user specified search terms. For example the user needs to be able to search for clock and radio. The issue is that I only want it to match separate comma separated values. So searching for clock and radio would only match were the field contains "clock, whatever, radio" and not "clock radio"
I need a regular expression that will match;
- the beginning of the string, a comma, or a space
- search term 1
- zero or more spaces
- then either a comma or the end of the string
then an OR and the same thing for search term 2.
Thank you in advance