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
