Mysql选择查询问题
我正在使用下面给出的查询:
SELECT o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.google_order_id, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name
FROM orders o, orders_status s, customers c
WHERE o.customers_id = c.customers_id
AND o.orders_status = s.orders_status_id
AND c.customers_firstname = Nisha
OR c.customers_lastname = Nisha
OR c.customers_email_address = Nisha
OR c.customers_telephone = Nisha
它给出的错误为:#1054 - Unknown columns 'Nisha' in 'where Clause'
Y 是这样吗?有人可以指导我解决这个问题吗?
I am using this below given query:
SELECT o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.google_order_id, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name
FROM orders o, orders_status s, customers c
WHERE o.customers_id = c.customers_id
AND o.orders_status = s.orders_status_id
AND c.customers_firstname = Nisha
OR c.customers_lastname = Nisha
OR c.customers_email_address = Nisha
OR c.customers_telephone = Nisha
and it gives me error as :#1054 - Unknown column 'Nisha' in 'where clause'
Y is it so? could some one guide me to resolve this?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
看起来您只需将 Nisha 括在引号中:
'Nisha'
此外,尽管与此错误无关,但请注意,您应该将
AND/OR
条件分组括号中的WHERE
条件:It looks like you simply need to enclose Nisha in quotes:
'Nisha'
In addition, although not related to this error, note that you should probably group
AND/OR
conditions of theWHERE
conditions in parenthesis: