MySQL 如何在WHERE子句中使用CONCAT_WS()函数？

当我们在WHERE子句中使用CONCAT_WS()函数时，输出将根据WHERE子句中提供的条件而确定。可以根据“Student”表的示例来理解如下。

阅读更多：MySQL 教程

例子

mysql> Select CONCAT_WS(' ',Name, Last_name, 'Resident of', Address, 'is studying', Subject)AS 'Student Detail' from student WHERE id = 20;
+----------------------------------------------------------------+
| Student Detail                                                 |
+----------------------------------------------------------------+
| Gaurav Rathore Resident of Jaipur is studying Computers        |
+----------------------------------------------------------------+
1 row in set (0.00 sec)