How to query who ends with mysql: 1. Use wildcards, such as "like '%正';"; 2. Use the left function, such as "right(title,1)='positive';" "; 3. Use the string interception function, with statements such as "substring(title,-1)='positive';".
Recommended: "mysql video tutorial"
Mysql query statements ending with a certain character
To query data ending with a certain character, it is often used in Mysql. Commonly used statements are:
The following is an example of querying the statements whose article titles end with the word "正":
1: Use wildcards:
SELECT * FROM `article` where title like '%正';
2: Use the left function :
SELECT * FROM `article` where right(title,1)='正';
3: Use string interception function:
SELECT * FROM `article` where substring(title,-1)='正';
The above is the detailed content of How to query who ends with mysql. For more information, please follow other related articles on the PHP Chinese website!