不灭的焱

革命尚未成功,同志仍须努力

作者:php-note.com  发布于:2020-02-25 10:59  分类:MySQL/NoSQL  编辑
SELECT LEFT(SeatId, 1) AS initial FROM wms_seat WHERE WareHouseId = 1 AND LEFT(SeatId, 1) REGEXP '[a-z]' GROUP BY initial