MySQL Common skills

1. Regular use will sacrifice a lot of system resources than like, try not to use

The regular syntax is about the same as JS PHP.

SELECT * from t1 where email REGEXP "@163[,." Com$ ";

SELECT * from t1 where email like "%@163.com" or email like "%@163,com"

Use of 2.REPLACE functions

UPDATE ' V9_zhushou ' SET ' thumb ' = REPLACE (' Thumb ', ' http://localhost/ciwei/', ' http://www.qciwei.com/ciwei/') WHERE ' ID ' > 0

UPDATE ' v9_zhushou_data ' SET ' iphone ' = REPLACE (' iphone ', ' http://localhost/ciwei/', ' http://www.qciwei.com/ciwei/') WHERE ' id ' = 300