Mysql fulltext full-text search instance tutorial

I have never noticed how to use mysql full-text search to query instance data. I wrote a search function for a friend today, starting with %? After half a day, the full-text search of fulltext is not ideal. Let's look at a simple example.

I have never noticed how to use mysql full-text search to query instance data. I wrote a search function for a friend today, starting with %? After half a day, the full-text search of fulltext is not ideal. Let's look at a simple example.

Let's start with the creation of full-text search.

First, create a one-person table as follows in the mysql DATA Command Prompt:

Create table Name (
-> Id INT AUTO_INCREMENT not null primary key,
-& Gt; title VARCHAR (200 ),
-> FULLTEXT (title)
-> );

In this case, our title is a full-text search index column. Below we will use match AGAINST for a simple example.

In mysql> Select * from table name where MATCH (title) AGAINST ('www .111cn.cn ')";

This will find out what we want. Well, the simple example of full-text search is here.