recommend jobs according to their skills in php sql

table applicants

CREATE TABLE `applicants` (
  `APPLICANTID` int(11) NOT NULL,
  `FNAME` varchar(90) NOT NULL,
  `USERNAME` varchar(90) NOT NULL,
  `PASS` varchar(90) NOT NULL,
  `EMAILADDRESS` varchar(90) NOT NULL,
  `SKILLS` text NOT NULL,
)

table job

CREATE TABLE `job` (
  `JOBID` int(11) NOT NULL,
  `CATEGORY` varchar(90) NOT NULL,
  `TITLE` varchar(90) NOT NULL,
  `SALARIES` double NOT NULL,
  `QUALIFICATION_WORKEXPERIENCE` text NOT NULL,
  `JOBDESCRIPTION` text NOT NULL,
  `DATEPOSTED` datetime NOT NULL,
)

As I want to match data from field SKILLS from table 'applicants' to the field TITLE and CATEGORY from table 'job' after string matching fetch all data(jobs) from table 'job'

Example:

   APPLICANTID= 1     SKILLS= ' graphic designer'   from table applicants

   JOBID=1   TITLE='it'
   JOBID=2   TITLE='graphic designer'
   JOBID=3   TITLE='sales'
   JOBID=4   TITLE='graphic designer'      from table job

expected output: JOBID=2 JOBID=4

Now suggest me sql query to meet the expected output or do any changes in the database?