==战神
select * from item where substring(CAST(num as varchar(9)),0,8)='2070010'
select * from item where substring(CAST(num as varchar(9)),0,8)='2070020'
select * from item where substring(CAST(num as varchar(9)),0,8)='2070030'
select * from item where substring(CAST(num as varchar(9)),0,8)='2070040'
select * from item where substring(CAST(num as varchar(9)),0,8)='2070050'
==祭祀7套
select * from item where substring(CAST(num as varchar(9)),0,8)='2870010'
select * from item where substring(CAST(num as varchar(9)),0,8)='2870020'
select * from item where substring(CAST(num as varchar(9)),0,8)='2870030'
select * from item where substring(CAST(num as varchar(9)),0,8)='2870040'
select * from item where substring(CAST(num as varchar(9)),0,8)='2870050'
==浪人7套
select * from item where substring(CAST(num as varchar(9)),0,8)='2470010'
select * from item where substring(CAST(num as varchar(9)),0,8)='2470020'
select * from item where substring(CAST(num as varchar(9)),0,8)='2470030'
select * from item where substring(CAST(num as varchar(9)),0,8)='2470040'
select * from item where substring(CAST(num as varchar(9)),0,8)='2470050'
== FS
select * from item where substring(CAST(num as varchar(9)),0,8)='2670010'
select * from item where substring(CAST(num as varchar(9)),0,8)='2670020'
select * from item where substring(CAST(num as varchar(9)),0,8)='2670030'
select * from item where substring(CAST(num as varchar(9)),0,8)='2670040'
select * from item where substring(CAST(num as varchar(9)),0,8)='2670050' |
