Skip to content

Instantly share code, notes, and snippets.

@ken-muturi

ken-muturi/new_gist_file.sql

Created November 17, 2013 06:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ken-muturi/7510103 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ken-muturi/7510103 to your computer and use it in GitHub Desktop.
Download ZIP
Boolean Full-Text Searches - http://viralpatel.net/blogs/full-text-search-using-mysql-full-text-search-capabilities/ It may happen that you want to specify certain keywords in your search criteria. Also you may want to ignore certain keywords. Boolean Full-Text Search can used to perform a full text search for such requirements. If you notice th…
Raw
new_gist_file.sql
SELECT * FROM articles WHERE MATCH (title,body)
AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);
Raw
new_gist_file2.sql
SELECT * FROM `icms3_log` WHERE MATCH (type,msg,severity) AGAINST ('+Error (>High <Medium)' IN BOOLEAN MODE)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment