store multiple values in single column in mysql

store multiple values in single column in mysql

table name :internship ,now i want to store "skill_required"for company
name XYZ like skill are: php , java etc mow Question is at the time of
company registration i have to specify text of or check box..etc and how
to store it in database ?with id ?like 1 for php 2 for java
2nd. when student search for internship then in field of interest he
specify php other student specify java ,so then company xyz must be
display for both student search as company is providing internship on php
and java both,so how to retrieve that form database,? there should be
separate table for skills with skill name and skill id?