【MySQL】mysql查询强制大小写及替换字段

强制大小写

select * from test where name like BINARY '%Adc%'

mysql替换字段

update test set name= REPLACE (name,'Abc','abc')