Before you jump and get a real Search Engine for your website, you might try the MySQL full text search feature.

It is incredibly easy to set up. All you need to do is setup the table and fields to be searchable as full text with the following command:

1
ALTER TABLE Table_Name ADD FULLTEXT(field1, field2);

Then, simply write a query using “match” to run your searches:

1
SELECT * FROM Table_Name WHERE MATCH (field1, field2) AGAINST ('search_query')

Happy Valentine’s Day

Filed under: Computing

Tagged with: , ,

Liked this page?

Tweet it

Subscribe to the RSS feed or sign up for the newsletter now.

Posts related to Enable Full Text Search with MySQL

Name (required)

Email (required)

Website

Leave a Reply

  • About Me


    photo of Samantha Halfon Samantha Halfon
    Software Engineer
    blueKiwi software
    Paris, France
    I enjoy playing with my computer(s), listening to Bob Dylan (and related artists) and watching movies (especially if they were directed by Martin Scorsese or John Cassavetes). Sometimes, I play a little guitar... If not doing any of the above, I am either riding a small red bike around Paris, or, making videos. About my videomaking please check out World Wide Angle and its blog.