S
sparkgun
Unregistered / Unconfirmed
GUEST, unregistred user!
select * from cargo_attribute
where
(cargo_companyId=1) and (cargo_name like '%') and (cargo_standard like '%22%') and
(cargo_serial like '%');
这一条一个也没查到
select * from cargo_attribute
where
(cargo_companyId=1) and (cargo_name like '%') and (cargo_standard like '%22%');
这一条就可以查到一个语句。
我用的数据库是oracle
where
(cargo_companyId=1) and (cargo_name like '%') and (cargo_standard like '%22%') and
(cargo_serial like '%');
这一条一个也没查到
select * from cargo_attribute
where
(cargo_companyId=1) and (cargo_name like '%') and (cargo_standard like '%22%');
这一条就可以查到一个语句。
我用的数据库是oracle