mysql - 错误 : #1054 - Unknown column 'NOPL' in 'where clause' ?

Question

为什么查询会给我这个错误:

#1054 - Unknown column 'NOPL' in 'where clause' ?

SELECT supplierprice.country, 
         supplierprice.networkname, 
         supplierprice.mcc, 
         supplierprice.mnc, 
         `288`.clientprice,
         `288`.ns, 
         client_list.currency
  FROM supplierprice
  INNER JOIN `288` 
  ON supplierprice.supp_price_id = `288`.net_id
  INNER JOIN client_list 
  ON `288`.clientid = client_list.clientid 
  WHERE `288`.ns <> `NOPL` ;

Answer 1

因为你使用`(引用字段/表/数据库引用)而不是'

我认为 NOPL 在你的 where 语句中是一个“字符串”