SQL statement, how can we query the first word of this field in the data table through a Chinese character?

Question

SQL statement, how can we query the first character of this field in the data table through a Chinese character?

Answer 1

Use wildcard character %. For example, you want to find a title that starts with "love".

SELECT * FROM Table Where 'title' like '爱%'