我查询一个表,同一个字段要比配很多的关键词,请大家看sql语句
------------------------------------
select * from kuaif_down_rj where (
rjfl like '%,29,%' or
rjfl like '%,30,%' or
rjfl like '%,31,%' or
rjfl like '%,32,%' or
rjfl like '%,33,%' or
rjfl like '%,34,%' or
rjfl like '%,35,%' or
rjfl like '%,36,%' or
rjfl like '%,37,%' or
rjfl like '%,38,%' or
rjfl like '%,39,%' or
rjfl like '%,40,%' or
rjfl like '%,41,%' or
rjfl like '%,42,%' or
rjfl like '%,43,%' or
rjfl like '%,44,%' or
rjfl like '%,45,%' or
rjfl like '%,46,%' or
rjfl like '%,47,%' or
rjfl like '%,48,%' or
rjfl like '%,49,%' or
rjfl like '%,50,%'
) order by time_h desc
-----------------------------------------
以上查询很慢,而且占cpu,大家有没有更好的查询方法?
没有分,希望大家能帮帮忙啊