通过ASCII查询
select product_id, shop_id,title,title_en from product where (ASCII(SUBSTR(title_en, 1, 1)) > 97) AND (ASCII(SUBSTR(title_en, 1, 1)) < 122) ;
通过ASCII查询
select product_id, shop_id,title,title_en from product where (ASCII(SUBSTR(title_en, 1, 1)) > 97) AND (ASCII(SUBSTR(title_en, 1, 1)) < 122) ;
转载于:https://www.cnblogs.com/zhuqixiong/p/11157663.html