How to Query MySQL Full Text Search Using MATCH and AGAINST

Here's how to set up and query a full text index in MySQL and MariaDB. This is the rough equivalent of SQL Server's really useful full text search.

00:00 - Introduction
00:30 - Create Index (phpMyAdmin)
01:40 - Create Index (MySQL Workbench)
02:27 - Querying the Full-Text Index
05:40 - Displaying Rank/Score of Matches
06:35 - Full-Text Search Documentation
07:25 - Natural Language Mode

Basic usage of MATCH and AGAINST:

SELECT * FROM TABLE_NAME WHERE MATCH(TABLE_NAME.COLUMN1_NAME, TABLE_NAME.COLUMN2_NAME) AGAINST('search keywords go here') LIMIT 0, 25

Remember that all of the columns in the MATCH clause must match the columns you have configured your full text index for in phpMyAdmin or MySQL Workbench.

Leave a LIKE if you found this tutorial useful and SUBSCRIBE for more coding videos. If you want me to make a video about any coding topic then leave suggestions in the comments below.

[dchubad]

Thanks for doing this video, This answered my question and solved my search problem. Thumbs up vote

[TinkerWithEmmo]

Nice explanation. This would help me in the project I'm working on

[theofficialdanish]

Thanks A Lot its helped in Traffic exchange website

[minutes]

Good One Thanks ..Please add slides also to the Video

[ThomPorter]

I wanted a refresher, and this was an excellent choice!
What's your website?

[Dloc]

it would have been helpful, if you provide the DB with the values in it.

[hairydonuts]

What about boolean mode? Kind of an omission don't you think?

[PabloPazosGutierrez]

How do you transform user search input into the AGAINST parameter? My guess is a normal user might not use the expected syntax. Thanks!

[WebDevStar]

How can do fulltext search for cjk (chinesse, Japanese, korean)