Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `Job`.`id`, `Job`.`job_description`, `Job`.`job_title`, `Company`.`name`, `Company`.`url`
- FROM `jobs` AS `Job`
- LEFT JOIN `companies` AS `Company`
- ON (`Company`.`id` = `Job`.`company_id` AND `Job`.`company_id` = `Company`.`id`)
- WHERE `Job`.`status` = 1 AND `Company`.`status` = 1
- AND ( MATCH(`Job`.`job_title`) AGAINST ('*' IN NATURAL LANGUAGE MODE) ) ORDER BY `Job`.`id` ASC LIMIT 20
- Error Code: 1064
- syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'
Add Comment
Please, Sign In to add comment