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!