Skip to content

Instantly share code, notes, and snippets.

@rbrahul

rbrahul/Fulltext-search.sql

Last active April 7, 2019 09:35
Show Gist options
  • Save rbrahul/d50f17914fdd295c4e706247d748db20 to your computer and use it in GitHub Desktop.
Save rbrahul/d50f17914fdd295c4e706247d748db20 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Fulltext-search.sql
select * from wp_posts where match(post_title, post_content) AGAINST ('best iphone to buy')
#ALTER TABLE wp_posts ADD FULLTEXT(post_title, post_content)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment