CONCAT() 函数如何与 MySQL WHERE 子句一起使用?
mysqlmysqli database更新于 2025/4/25 10:20:17
假设我们想要从表"Student"连接列"Name"、"Address"和"Columns"的值，条件是，该条件也是 WHERE 子句中提供的列"Name"和"Subject"的值的连接，并借助 CONCAT() 函数。我们可以使用以下查询给出输出 −
mysql> Select CONCAT(Name, ' ', 'Resident of', ' ', Address,' ','is',' ', 'Studying',' ', Subject)AS 'Detail of Student' from Student WHERE CONCAT(Name, Subject) = "AaravHistory"; +----------------------------------------------+ | Detail of Student | +----------------------------------------------+ | Aarav Resident of Mumbai is Studying History | +----------------------------------------------+ 1 row in set (0.00 sec)
相关文章
有用资源
mysql 参考教程 - 该教程包含有关 mysql 的更多信息:https://www.cainiaomax.com/mysql/
