各自数据库有不同的匹配符号
比如oracle
select * from xxx where column1 like 'www%';
select * from xxx where column1 like 'www_';mssql?
select * from xxx where column1 like 'www*';是这样么?不知道,呵呵
比如oracle
select * from xxx where column1 like 'www%';
select * from xxx where column1 like 'www_';mssql?
select * from xxx where column1 like 'www*';是这样么?不知道,呵呵
select * from xxx where column1 like '%www%'
from table
where column1 = 'xxxx' and
column2 like '%xxx%';