matching comma seperated value from a string in mysql -

matching comma seperated value from a string in mysql -

i have table job_registration having next construction

id name email keyskills 1 a@a.in java,sqlserver 2 b b@b.in java,php,mysql,sqlserver 3 c c@c.in mysql,sqlserver

i want fetch email of people has keyskills sqlserver. please suggest

thanks in advance

use regexp match text in column

select email job_registration keyskills regexp 'sqlserver'

mysql