a guest Dec 17th, 2018 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
  8. Error Code: 1064
  9. syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand