mysql判断字符串是否以某个字符开头
2019-12-18 本文已影响0人
hemingkung
SELECT
id,
symbol
FROM
vdb_gene
WHERE
FIND_IN_SET(SUBSTRING(`symbol`,1,1), 'A,B,C')
SELECT
id,
symbol
FROM
vdb_gene
WHERE
FIND_IN_SET(SUBSTRING(`symbol`,1,1), 'A,B,C')