Guest User

Untitled

a guest
Dec 17th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. SELECT `Job`.`id`, `Job`.`job_description`, `Job`.`job_title`, `Company`.`name`, `Company`.`url`
  2. FROM `jobs` AS `Job`
  3. LEFT JOIN `companies` AS `Company`
  4. ON (`Company`.`id` = `Job`.`company_id` AND `Job`.`company_id` = `Company`.`id`)
  5. WHERE `Job`.`status` = 1 AND `Company`.`status` = 1
  6. AND ( MATCH(`Job`.`job_title`) AGAINST ('*' IN NATURAL LANGUAGE MODE) ) ORDER BY `Job`.`id` ASC LIMIT 20
  7.  
  8. Error Code: 1064
  9. syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'
Add Comment
Please, Sign In to add comment