How does Mysql query the statement that starts with what character?

Sentence method of which character mysql query starts with: 1. Use wildcard query, the code is [SELECT * FROM `article` where title like 'positive%';]; 2. Use left function query, the code is [where left(title,1)]. What character does mysql query start with: 1: Use wildcards: SELECT * FROM `article` where title like ‘positive%’; 2: Use the left function: SELECT * FROM `article ` where left(title,1)='positive'; 3: Use the string interception function: SELECT * FROM `article` where substring(title,1,1)='正'; More related free learning recommendations:mysql tutorial(Video) The above is the detailed content of how Mysql queries the statement starting with what character. For more, please pay attention to other related articles on 1024programmer.com!