thanks 。you are right。 Single quotes are escaped by doubling them up.
发件人：JiaTao Tao <[email protected]>
发送日期：2018-12-19 16:28:48
收件人：[email protected]
主题：Re: use single quote in sql ,how to escape>Hi
>In SQL, Single quotes are escaped by doubling them up. Try this: select *
>from buzz_info where title like '%hello i'' am kangkan%'
>
>By the way, Kylin is not suitable for answer "select *", see this:
>Why I got an error when running a “select * “ query? (
>http://kylin.apache.org/docs/gettingstarted/faq.html)
>
>黄云尧 <[email protected]> 于2018年12月19日周三 上午8:15写道：
>
>> the sql : select * from buzz_info where title like '%hello i'
>> am kangkan%'
>>
>>
>> but it is a worry grammar,how to escape by use single quote.
>>
>>
>> I am looking forward to your reply
>>
>>
>>
>>
>>
>>
>>
>
>--
>
>
>Regards!
>
>Aron Tao
