关于 ibatis like 用法转
Sql代码
1.SELECT * 2. FROM user 3. WHERE username like '%' || #username# || '%' SELECT * FROM user WHERE username like '%' || #username# || '%'
其实上面的语句是针对Oracle 的,对于不同数据字符串连接符不一样。现列举mysql和SQLServer如下:
Mysql:
Sql代码 1.SELECT * 2. FROM user 3. WHERE username like CONCAT('%', #username#, '%') SELECT * FROM user WHERE username like CONCAT('%', #username#, '%')
SQLServer:
Sql代码 1.SELECT * 2. FROM user 3. WHERE username like '%' + #username# + '%' SELECT * FROM user WHERE username like '%' + #username# + '%'
-----------------------------------------------------------------------------------------------------------------------------
关于数据库字符串连接符简单列举我使用过的一些数据库如下:
Oracle SQLServer Mysql DB2
|| 或 CONCAT() + CONCAT() || 或 CONCAT()