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