最终要实现效果,如下:
"mysql查询语句"
SELECT t1.id, t1.name, t2.f_PY
FROM table_name t1, table_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 g...
3-31 4,790 views
最终要实现效果,如下:
"mysql查询语句"
SELECT t1.id, t1.name, t2.f_PY
FROM table_name t1, table_coslers t2
WHERE CONV(HEX(LEFT(CONV...