How does php + mysql Query The Chinese character database based on the first letter of the pinyin alphabet?

How does php + mysql Query The Chinese character database based on the first letter of the pinyin alphabet? How does php + mysql Query The Chinese character database based on the first letter of the pinyin alphabet?
For example, search for lah, mysql Query results such as 'pull flowers, pull goods, pull flowers jobs, pull flowers stickers waist line, pull flowers stickers, pull red, pull goods Hongguang ';
How can this problem be achieved?

Reply to discussion (solution)

You can add a field for storing the first letter in the database. when adding Chinese characters to the database, you can add the corresponding first letter string. there is a program for generating the first letter on the Internet.