#sql("getByPage")
select * from T_User where 1=1
#if(name!=null && name!='') and name like '%'+#para(name)+'%' #end
order by id
#end
上面的语句用mssql能正常执行,但用mysql就报错了,请问怎么解决?
https://www.jfinal.com/doc/5-13
mysql 下的 like 是这么用的:
#sql("search")
select * from article where title like concat('%', #para(title), '%')
#end