PHP笔记网

作者：Albert.Wen 添加时间：2020-10-01 10:58:55 修改时间：2024-12-13 06:03:14 分类：MySQL/Redis 编辑

SELECT
    LEFT(SeatId, 1) AS initial
FROM
    wms_seat
WHERE
    WareHouseId = 1 AND LEFT(SeatId, 1) REGEXP '[a-z]'
GROUP BY
    initial