本文介绍了MySQL选择与CONCAT条件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
限时送ChatGPT账号..
我正在尝试在脑海中编译这个..我有一个包含名字和姓氏字段的表我有一个字符串，如Bob Jones"或Bob Michael Jones"等.
I'm trying to compile this in my mind.. i have a table with firstname and lastname fields and i have a string like "Bob Jones" or "Bob Michael Jones" and several others.
问题是，我有例如名字中的鲍勃，以及姓氏中的迈克尔·琼斯
the thing is, i have for example Bob in firstname, and Michael Jones in lastname
所以我想
SELECT neededfield, CONCAT(firstname, ' ', lastname) as firstlast
FROM users
WHERE firstlast = "Bob Michael Jones"
但它说未知的列firstlast"..有人可以帮忙吗?
but it says unknown column "firstlast".. can anyone help please ?
推荐答案
您提供的别名用于查询的输出 - 它们在查询本身中不可用.
The aliases you give are for the output of the query - they are not available within the query itself.
您可以重复该表达式:
SELECT neededfield, CONCAT(firstname, ' ', lastname) as firstlast
FROM users
WHERE CONCAT(firstname, ' ', lastname) = "Bob Michael Jones"
或包装查询
SELECT * FROM (
SELECT neededfield, CONCAT(firstname, ' ', lastname) as firstlast
FROM users) base
WHERE firstLast = "Bob Michael Jones"
这篇关于MySQL选择与CONCAT条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！