Mysql数据库
sql = " and indexNum like concat('%',?,'%') "
Oracle||DB2
sql = " like '%' || ? || '%' "
SQL Server
sql = " like '%' + ? + '%' "
例如:select * from test where testname like '%' || '赵' || '%'
Mysql数据库
sql = " and indexNum like concat('%',?,'%') "
Oracle||DB2
sql = " like '%' || ? || '%' "
SQL Server
sql = " like '%' + ? + '%' "
例如:select * from test where testname like '%' || '赵' || '%'
© 著作权归作者所有