mysql 模糊查询和正则

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'