从数据库中检索内容时,仅显示第一列的第一个字母,如下所示
SELECT LEFT(`name`, 1) AS first_letter FROM register
我想从数据库中检索多列。到底有吗..??
只需在 select 语句中列出逗号分隔
SELECT LEFT(`name`, 1) AS first_letter_name,
LEFT(`second_col`, 1) AS first_col2,
LEFT(third_col, 1) AS first_letter_col3,
FROM register