SELECT t1.id, t1.name, t2.f_PY
FROM t_user t1, t_coslers t2
WHERE CONV(HEX(LEFT(CONVERT(t1.name USING gbk ), 1)), 16, 10) BETWEEN t2.cBegin AND t2.cEnd
ORDER BY convert(t1.name using gbk) ASC 最佳答案
SELECT t1.id, t1.name, t2.f_PY
FROM t_user t1, t_coslers t2
WHERE CONV(HEX(LEFT(CONVERT(t1.name USING gbk ), 1)), 16, 10) BETWEEN t2.cBegin AND t2.cEnd
ORDER BY convert(t1.name using gbk) ASC