像SQL一样的错误 [英] sql like error

问题描述

此SQL代码给我一个错误:

This SQL code is giving me an error:

select b.* from from exlltala as a,Ghasht as b where 

b.field3 like %(substring (codposti ,6,1)%))

推荐答案

从Query中删除中的多个.

我可以看到您的查询完全乱七八糟.

您能否告诉我们您的场景IMO，您想从Sql Tables获得什么.

我可以看到整个查询有很多错误.

Remove multiple from from Query.

I can see a complete mess with your query.

Could you please tell us your scenarion IMO what you want from your Sql Tables.

I can see whole query have many errors.

尝试以下查询...

Hi,

Try the following query...

select b.* from exlltala as a,Ghasht as b where
b.field3 like ''%''+substring (''codposti'',6,1)+''%''

错误:

*两次使用"from"关键字
*"Char"值中缺少单引号.
*使用like运算符缺少单引号.(例如:like''％a％'')


干杯:)

Mistakes:

* Two times using ''from'' keyword
* single quote missing in ''Char'' value.
* Single quote missing using like operator.(Ex: like ''%a%'')


Cheers :)

尝试一下，

Try this,

select b.* from exlltala as a,Ghasht as b where
b.field3 like '%'+substring (codposti,6,1)+'%'

这篇关于像SQL一样的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！