嗨,当我致电此查询以选择此项工作并取得输出时

select SUBSTR(img_address1,LOCATE('/',img_address2)+1,36)fROM content


但是当我进行此查询时会出错

SELECT id from content WHERE ((SUBSTR(img_address2,LOCATE('/',img_address2)+1,5) LIKE'salam')


这也使错误

SELECT id from content WHERE ((SUBSTR(img_address2,LOCATE('/',img_address2)+1,5) = 'salam')


我的错误是:

SELECT id from content WHERE ((SUBSTR(img_address2,LOCATE('/',img_address2)+1,5) = 'salam') LIMIT 0, 25
MySQL said: Documentation

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 25' at line 1

最佳答案

(之前有一个额外的方括号SUBSTR。删除它可以修复错误。

SELECT id from content WHERE (SUBSTR(img_address2,LOCATE('/',img_address2)+1,5) = 'salam') LIMIT 0, 25

10-07 19:10
查看更多