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

The editor will share with you an example of what characters mysql queries begin with. I hope you will learn a lot after reading this article. Let's discuss it together.

The statement method that mysql query begins with: 1. Use wildcard to query, code is [SELECT * FROM `roomle` where title like 'positive%';]; 2, use left function to query, code is [where left (title,1)].

The statement method that the mysql query begins with:

1: use wildcards:

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

2: use the left function:

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

3: use the string interception function:

SELECT * FROM `roomle` where substring (title,1,1) = 'positive'. After reading this article, I believe you have some understanding of what characters mysql queries begin with. If you want to know more about it, please follow the industry information channel. Thank you for your reading!

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.