x-x字符串排序sql

x-x.sql

SELECT * FROM ( 
 SELECT *, CONVERT(SUBSTRING_INDEX(invite_num_range, '-', 1),SIGNED) AS lower,
 CONVERT(SUBSTRING_INDEX(invite_num_range, '-' ,- 1),SIGNED) AS upper 
 FROM jmf_invite_reward_config) AS a
WHERE 0 BETWEEN a.lower-1 AND a.upper ORDER BY a.lower+1