You are welcome! 黄云尧 <yunyao.hu...@transsnet.com> 于2018年12月19日周三 上午8:33写道:
> thanks 。you are right。 Single quotes are escaped by doubling them up. > 发件人:JiaTao Tao <taojia...@gmail.com> > 发送日期:2018-12-19 16:28:48 > 收件人:dev@kylin.apache.org > 主题: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) > > > >黄云尧 <yunyao.hu...@transsnet.com> 于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 > > > -- Regards! Aron Tao