Introduction to fuzzy query method using instr in mysql

Using the internal function instr in MySQL can replace the traditional like query method and is faster.

The instr function takes the field as its first argument and the string to be queried as its second argument. It returns the position of the string. The first one is 1, and if it is not found, it is 0.

For example, to query names with "军" in the field name, the traditional method is:

select name from user table where name like `%军%';

Using the instr method:

select name from user table where instr('name','军');

or:

select name from user table where instr('name','军')>0;

Table A

Field: Name

Zhang San
Wang Wu

Table B

Field: title

Information is published in three parts
Information released by Wang Wu
Information is released three times

Ranking list, sort by the number of entries where the name like %'name'% in table A matches the title in table B,

select name,count(b.title) from a inner join b on instr(b.title,a.name)>0 group by name order by count(b.title)

Summarize

The above is all the content of this article about the use of instr for fuzzy query method in MySQL. I hope it will be helpful to everyone. Interested friends can continue to refer to this site: Detailed explanation of the meanings of N and M in the MySQL data type DECIMAL(N,M), a brief analysis of the differences between FIND_IN_SET() and IN in MySQL, etc. If you have any questions, you can leave a message at any time and the editor will reply to you in time. Thank you friends for supporting this site!