mysql中正则函数
REPLACE
REGEXP
replace()
regexp()
rlike
not rlike
UPDATE testDataTable SET url=REPLACE(url,'http://www.sxfenglei.com/test/imgs', 'images');
UPDATE testDataTable SET url=REPLACE(url,'.swf', '.gif');
SELECT * FROM testDataTable WHERE url REGEXP '^http'
SELECT * FROM testDataTable WHERE url REGEXP '.jpeg$'
SELECT * FROM testDataTable WHERE url like '%.jpeg'