MySQL - 连接两个字段并在 WHERE 子句中使用它们 [英] MySQL - CONCAT two fields and use them in WHERE clause

问题描述

正如标题所暗示的，我想知道如何在 mysql 的 where 子句 中concat 两个字段.这是我正在努力实现的一个例子:

As the title suggests, I was wondering how to concat two fields in a where clause in mysql. This is an example of what I'm trying to achieve :

SELECT CONCAT_WS(' ', first_name, last_name) AS name FROM `users`
WHERE name LIKE "%John Doe%"

重点是 first_name 和 last_name 是单独的字段，我想让我的 PHP 应用程序搜索全名.

The point is that first_name and last_name are separate fields, and I want to enable my PHP application to search for a full person's name.

有什么建议吗?

干杯！

推荐答案

试试这个 ::

SELECT CONCAT_WS(' ', first_name, last_name) AS name FROM `users`
WHERE CONCAT_WS(' ', first_name, last_name) LIKE "%John Doe%"

这篇关于MySQL - 连接两个字段并在 WHERE 子句中使用它们的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！