去掉 select abcd=replace('aaaabbbcccddd','bbb','') from yourtable where abcd='aaaabbbcccddd' 代替 select abcd=replace('aaaabbbcccddd','bbb','eee') from yourtable where abcd='aaaabbbcccddd'查出值为AAAA的记录 select * from yourtable where abcd like 'aaaa%'
替换,用replace函数 update 你的表 set abcd=replace('aaaabbbcccddd','bbb','eee') 查出值为AAAA的记录 select * from 你的表 where abcd like 'aaaa%' 或 select * from 你的表 where left(abcd,4)='aaaa'
select abcd=replace('aaaabbbcccddd','bbb','') from yourtable
where abcd='aaaabbbcccddd'
代替
select abcd=replace('aaaabbbcccddd','bbb','eee') from yourtable
where abcd='aaaabbbcccddd'查出值为AAAA的记录
select * from yourtable where abcd like 'aaaa%'
update 你的表 set abcd=replace('aaaabbbcccddd','bbb','eee')
查出值为AAAA的记录
select * from 你的表 where abcd like 'aaaa%'
或
select * from 你的表 where left(abcd,4)='aaaa'