讨论数量:
SELECT * FROM
sci_article_journal
WHERE ( (keywords
LIKE '%gastric cancer%') OR (title
LIKE '%gastric cancer%') ) ORDER BYpublication_time
; 这条sql时间:0.155sSELECT * FROM
sci_article_journal
WHERE ( (instr (keywords
, 'gastric cancer') > 0) OR (instr (title
, 'gastric cancer') > 0) ) ORDER BYpublication_time
; 这条sql时间:0.252s这明显你这种写法时间过长
推荐文章: