Hello all,
I have a string in column exerciseTypes in a database named exercises. The string contains values separated by '&'. I am trying to search the database for all instances where a specific substring is located inside of the string contained in column exerciseTypes.

ex:
string: "pullups&situps&calf raises"
subdtring i am looking for: 'situps'

Right now I am selecting all of the rows in the database and searching for the substring using the strpos() function in PHP. I know there must be a more efficient way of doing this. I have looked into the LOCATE and am not sure if it is correct for this application. Any help would be appreciated.

Thanks in Advance,

Phil V

If I understand you problem correctly that would appear to be the right thing to do, it will probably look like this:

oh man...thanks that is much easier to read. Thanks again for your help

-Phil V