1.把表tableName中字段cardcode中含“AA:”的替换为“BB:” :
UPDATE tableName SET cardcode = REPLACE(`cardcode`, 'AA:','BB: ') WHERE INSTR(`cardcode`,'AA:') > 0
2.查找表tableName中指定号码段的记录:
SELECT * FROM tableName WHERE mobile REGEXP '^1(3|5|8)[0-9]{9}$'
1.把表tableName中字段cardcode中含“AA:”的替换为“BB:” :
UPDATE tableName SET cardcode = REPLACE(`cardcode`, 'AA:','BB: ') WHERE INSTR(`cardcode`,'AA:') > 0
2.查找表tableName中指定号码段的记录:
SELECT * FROM tableName WHERE mobile REGEXP '^1(3|5|8)[0-9]{9}$'