Does mysql support like?

mysql supports like, which can match any multi-character or fuzzy match any single character, and will be used in combination with "%" and "_"; for example, "%a" matches data ending with a, " %a%" matches data containing a, "_a_" matches data with three digits and the middle letter is a, etc.

Using Like in MySQL for fuzzy query

The so-called "fuzzy query" corresponds to the "precise query" Come. For example, if we want to query whether a field value is equal to 1, we can write "where column=1" in the SQL statement. This is an exact query. Precise query is very simple and easy to understand, but we often use fuzzy query. For example, I want to query a user from the user table, but I can't remember his name. I only know that there is "Hong" in his name. words, then fuzzy query comes in handy.

like match/fuzzy match, will be used in combination with % and _.

'%a'     //以a结尾的数据
'a%'     //以a开头的数据
'%a%'    //含有a的数据
'_a_'    //三位且中间字母是a的
'_a'     //两位且结尾字母是a的
'a_'     //两位且开头字母是a的

Query information starting with the java field.

SELECT * FROM position WHERE name LIKE 'java%';

Query information containing java fields.

SELECT * FROM position WHERE name LIKE '%java%';

Query information ending with java field.

SELECT * FROM position WHERE name LIKE '%java';

Recommended tutorial: mysql video tutorial

The above is the detailed content of Does mysql support like?. For more information, please follow other related articles on the PHP Chinese website!