Q: How can I query the information of a student surnamed Zhang in the student data table?
1. Fuzzy query keyword: like
2. For multiple arbitrary characters:%
3. To represent an arbitrary character, use:_
example: SELECT * FROM ` ceshi1 ` WHERE ` name ` LIKE 'Zhang%';
Scope of application: It is suitable for querying information of any length starting with a certain character.
Q: How can I query the student information of a student whose surname is Zhang and whose first name is only two words in the student data table?
example: SELECT * FROM ` ceshi1 ` WHERE ` name ` LIKE 'Song _';
Scope of application: It is suitable to limit the length of the query string.
