PHP笔记网

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