select * from ky_message where msg_to='系统' or msg_to=? or msg_title=? or msg_title=? or msg_title=? order by msg_id desc 给msg_id建立clustered index(desc) 并使用in如: select *from ky_message where msg_to in ('系统','?') or msg_title in (?,?) 可以考虑使用union句子合并查询比如: select * from ky_message where msg_to in('系统','?') union select * from ky_message where msg_title in(?,?);
show index from ky_message
哦,索引是没有的,只有msg_id是主键.
select *from ky_message where msg_to in ('系统','?') or msg_title in ('?','?','?') order by msg_id desc
给msg_id建立clustered index(desc)
并使用in如:
select *from ky_message where msg_to in ('系统','?')
or msg_title in (?,?)
可以考虑使用union句子合并查询比如:
select * from ky_message where msg_to in('系统','?')
union
select * from ky_message where msg_title in(?,?);
or msg_title in ('?','?','?')
order by msg_id desc