Scriptlance data feed and MySQL

[liam1412]

Is there a more efficient way of checking if a mysql cell contains a certain string without extracting the data and exploding into an array.

 

I am trying to use the scriptlance data feed and I am going to input this data into a mysql DB.  I want to keep the Categories as is so they will be in the mysql field as php | mysql | data entry.

 

I want to then allow people to search by category, so If they select php I want to perform a search of the DB by category and extract any line where the category field contains the string PHP

 

Thanks for you help