Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of who the mysql query ends with. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Mysql query to whom the end of the method: 1, the use of wildcards, statements such as "like'% positive';"; 2, the use of left functions, statements such as "right (title,1) = 'positive';"; 3, the use of string interception functions, statements such as "substring (title,-1) = 'positive';"

Mysql query statements that end with a character

Querying data that ends with a character is often used in Mysql. The commonly used statements are:

The following is an example of a statement that queries an article title that ends with the word "positive":

1: use wildcards:

SELECT * FROM `roomle`where title like'% positive'

2: use the left function:

SELECT * FROM `roomle`where right (title,1) = 'positive'

3: use the string interception function:

SELECT * FROM `roomle` where substring (title,-1) = 'positive'. This is the end of the mysql query. I hope the above content can be helpful to you and learn more. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.