表1
F_ID F_code F_name
1 20060530-0570130001 aaaa
2 20060530-0570130002 bbbb
1 20060531-0570130001 cccc我想把2006-05-30开头的记录查出来!
F_ID F_code F_name
1 20060530-0570130001 aaaa
2 20060530-0570130002 bbbb
1 20060531-0570130001 cccc我想把2006-05-30开头的记录查出来!
select * from 表1
where f_code like '20060530%'