sql语句处理问题

Question

如下：有张表

id    sql_field
1     SELECT * FROM (`abc`) WHERE (telnu = "1" OR telnum2 = "2") ORDER BY `lastupdate` DESC;    
2     SELECT * FROM (`abc`) WHERE (telnu = "1" OR telnum2 = "22") ORDER BY `lastupdate` DESC; 
3     SELECT * FROM (`abc`) WHERE (telnu = "1" OR telnum2 = "12") ORDER BY `lastupdate` DESC; 
4     SELECT * FROM (`abc`) WHERE (telnu = "1" OR telnum2 = "42") ORDER BY `lastupdate` DESC; 
5     SELECT * FROM cdb WHERE digest<10 AND displayorder >=43 AND fid=55 ORDER BY tid DESC LIMIT 0, 10; 
6     SELECT * FROM cdb WHERE digest>30 AND displayorder >=12 AND fid=55 ORDER BY tid DESC LIMIT 0, 10; 
7     SELECT * FROM cdb WHERE digest>10 AND displayorder >=2 AND fid=55 ORDER BY tid DESC LIMIT 0, 10; 
                    。
                    。
                    。

里面的sql_field 字段中有很多类似但不重复的查询语句，怎么样一个类型的查询语句只保留一个呢，求指导

Answer 1

把变动的数量当做参数传入查询语句中，比如第一类的telnu 和telnum2，每次调用的时候传入具体的查询值即可

Answer 2

SELECT * FROM (`abc`) WHERE telnu = "1" OR telnum2 in("2","22","12","42") ORDER BY `lastupdate` DESC; SELECT * FROM cdb WHERE ( (digest<10 AND displayorder >=43) OR (digest>30 AND displayorder >=12) OR (digest>10 AND displayorder >=2) ) AND fid=55 ORDER BY tid DESC LIMIT 0, 10;

Answer 3

between（$xxx）

Answer 4

跟题主说一下，凌丶这个答案是不对的，between是在一个范围内，此处应该用in，一楼是正解