MySQL查询与别名WHERE不匹配 [英] MySQL query match with alias WHERE not working

问题描述

为什么我的sintax不正确?

why does my sintax is not right?

SELECT *,
           MATCH(tags,title,description) AGAINST ('asd jhbdckdsb' IN BOOLEAN MODE) AS score 
      FROM blogs WHERE score > 0
  ORDER BY score DESC, insert_datetime DESC, id DESC ; 

该问题似乎在WHERE条件下:/

the problem seems to be on WHERE condition :/

推荐答案

WHERE中不允许使用不可见的列和列别名，因此请使用HAVING

invisible columns and column alias are not allowed in WHERE so use HAVING

HAVING score > 0而不是WHERE

这篇关于MySQL查询与别名WHERE不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！