MySQL选择带有CONCAT条件

您提供的别名用于查询的输出-在查询本身中不可用。

您可以重复表达：

SELECt neededfield, CONCAt(firstname, ' ', lastname) as firstlast FROM usersWHERe CONCAt(firstname, ' ', lastname) = "Bob Michael Jones"

或包装查询

SELECt * FROM (  SELECt neededfield, CONCAt(firstname, ' ', lastname) as firstlast   FROM users) base WHERe firstLast = "Bob Michael Jones"