select * from tb_pan where p_Boss='1111' or p_lBoss='1111'
or p_rBoss='1111' or p_new1='1111' or p_new2='1111' or p_new3='1111' or p_new4='1111'
红色的是表,蓝色是列
能把where后边的缩短点不?contains()可以么?
...全文
14615打赏收藏
能把这个sql语句优化一下么
select * from tb_pan where p_Boss='1111' or p_lBoss='1111' or p_rBoss='1111' or p_new1='1111' or p_new2='1111' or p_new3='1111' or p_new4='1111' 红色的是表,蓝色是列 能把where后边的缩短点不?contains()可以么?
[Quote=引用楼主 kk297173176 的回复:]
select * from tb_pan where p_Boss='1111' or p_lBoss='1111'
or p_rBoss='1111' or p_new1='1111' or p_new2='1111' or p_new3='1111' or p_new4='1111'