php - sql 搜索查询仍未产生预期结果

Question

我需要一个计数和搜索查询才能正常工作。计数查询似乎工作正常，但搜索查询却无法正常工作。

计数查询:

SELECT COUNT(DISTINCT tg_id) 
  FROM tg_keywords 
 WHERE tg_keyword LIKE 'keyword_1' OR tg_keyword LIKE 'keyword_2' 
 ORDER BY tg_keyword LIKE 'keyword_1' AND tg_keyword LIKE 'keyword_2 DESC
Returns 1 count as expected.

搜索查询:

SELECT DISTINCT tg_keywords.tg_id 
  FROM tg_keywords LEFT JOIN tg_info.tg_id=tg_keywords.tg_id 
 WHERE tg_keyword LIKE 'keyword_1' OR tg_keyword LIKE 'keyword_2' 
 ORDER BY tg_keyword LIKE 'keyword_1' AND tg_keyword LIKE 'keyword_2' DESC, tg_info.date_added LIMIT 16 OFFSET 1
Returns 0 results (1 is expected)

如有任何建议，我们将不胜感激

提前致谢，阿奇

Answer 1

删除查询末尾的OFFSET 1，然后尝试。

OFFSET 1 告诉它为您提供第二行中的记录。要么将其设为 OFFSET 0，要么将其完全删除。