In MYSQL, I have a table field that looks like this:
"bobby,ryan,bryan,john"
I want to do a regular expression search on that field and return yes or no if "bob" is in it. "bob" is part of bobby, but I would want a search like this to be false. I only want true if bob is actually in there separated by a comma or at the beginning or end of the string. How do I do this?
Mark