模糊查询
mysql | select * from t_user where name like cancat(’%’,’$(name)’,’%’) |
---|---|
SQL server | select * from t_user where name like ‘%’+#{name}+’%’ |
oracle | select * from t_user where name like ‘%’||#{name}||’%’ |
Oracle
- 时间比较
select * from user where add_time >to_date(‘2018-6-23 23:13:22’,‘yyyy-MM-dd hh24:mi:ss’)