嗨,当我致电此查询以选择此项工作并取得输出时
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