Skip to content

Instantly share code, notes, and snippets.

@oleander

oleander/gist:911766

Created April 9, 2011 20:54
Show Gist options
  • Save oleander/911766 to your computer and use it in GitHub Desktop.
Save oleander/911766 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT DISTINCT movies.*
FROM `movies`
INNER JOIN `torrents` ON `torrents`.`movie_id` = `movies`.`id`
WHERE MATCH (torrents.title) AGAINST('String', IN BOOLEAN MODE)
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' IN BOOLEAN MODE)' at line 4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment