mysql: select * from test where school_name like concat('%',${name},'%')
oracle: select * from test where school_name like '%'||${name},'%'
SQL Server:select * from test where school_name like '%'+${name},+'%'
mysql: select * from test where school_name like concat('%',${name},'%')
oracle: select * from test where school_name like '%'||${name},'%'
SQL Server:select * from test where school_name like '%'+${name},+'%'
转载于:https://www.cnblogs.com/huiy/p/7252579.html