sql - string search in MySQL Query -

my mysql field having skills field(string) like,

1)php,mysql 2)java 3)java,c 

i need select column skills field condition. condition may like,

skills="php"    // o/p => 1st column or skills = "mysql,c"   // o/p => 1st , 3rd column 

how can write query.? here im using php.

one way it

select *   table1  skills '%mysql%'      or skills '%c%' 

sqlfiddle

it easier if you'd normalized data