#查询并更新表中数据
update t_test set test = substr(test,3) where '0x'=substr(test,1,2) and id=1; #更新单条
update t_test set test = substr(test,3) where '0x'=substr(test,1,2) ; #更新多条
#查询并更新表中数据
update t_test set test = substr(test,3) where '0x'=substr(test,1,2) and id=1; #更新单条
update t_test set test = substr(test,3) where '0x'=substr(test,1,2) ; #更新多条