php简单sql,请教一个简单的SQL

请教一个简单SQL:

select * from eload_goods where goods_sn like '(select left(goods_sn,9) as goods_sn from eload_goods where goods_id = 126300 limit 1)%'

这个SQL有啥错误?搜不到结果.

select * from eload_goods where goods_sn = (select left(goods_sn,9) as goods_sn from eload_goods where goods_id = 126300 limit 1)

这样有搜索是有结果的.

注:子查询是正确的.子查询返回结果为:IE0384701

goods_sn为varchar数据类型

回复讨论(解决方案)

请问加个%是啥意思

没有错

但我绝不相信你的表中有 (select left(goods_sn,9) as goods_sn from eload_goods where goods_id = 126300 limit 1)... 这样的字符串

没有错

但我绝不相信你的表中有 (select left(goods_sn,9) as goods_sn from eload_goods where goods_id = 126300 limit 1)... 这样的字符串

版主,您错了.

(select left(goods_sn,9) as goods_sn from eload_goods where goods_id = 126300 limit 1)是绝对正确的.也有这样的字符串.

问题己解决,附上答案:

SELECT * FROM eload_goods WHERE goods_sn LIKE (SELECT CONCAT(LEFT(goods_sn,9),'%') AS goods_sn FROM eload_goods WHERE goods_id = 126300 LIMIT 1)

我错在哪？

select * from eload_goods where goods_sn like '(select left(goods_sn,9) as goods_sn from eload_goods where goods_id = 126300 limit 1)%'

不知字符串吗

SELECT * FROM eload_goods WHERE goods_sn LIKE (SELECT CONCAT(LEFT(goods_sn,9),'%') AS goods_sn FROM eload_goods WHERE goods_id = 126300 LIMIT 1)

这样的sql不蛋疼吗？

我错在哪？

select * from eload_goods where goods_sn like '(select left(goods_sn,9) as goods_sn from eload_goods where goods_id = 126300 limit 1)%'

不知字符串吗

MYSQL的子查询不支持limit,应该是limit 1导致的错误吧

如果goods_id是主键的话，limit 1完全没有必要，而且不被支持

错误的原因在于单引号，单引号中的内容并没有进行查找，而是直接将引号内容区匹配了

SELECT * FROM eload_goods WHERE goods_sn LIKE (SELECT CONCAT(LEFT(goods_sn,9),'%') AS goods_sn FROM eload_goods WHERE goods_id = 126300 LIMIT 1)

这样的sql不蛋疼吗？

请问如何写更好？

我错在哪？

select * from eload_goods where goods_sn like '(select left(goods_sn,9) as goods_sn from eload_goods where goods_id = 126300 limit 1)%'

不知字符串吗

我理解你的意思，'select...' 是字符串，所以我是请教解决的写法嘛。

本文原创发布php中文网，转载请注明出处，感谢您的尊重！