REGXP Expert

Zi5 · June 22, 2010, 2:34am

Hello Everyone ,

I’ve a very hard regular expression situation , and i try to fix it many times but all my tries failed .

I want to use MySQL change/replace statment in this way

Search For :-

UTF-8 Links

Explain:-

Change With:-

Explain:-

The UTF-8 links lentgh is differnet from one to other , but all of them has the same style and end in this way

309560.html

309561.html

Which it means the Thread iID

I want to do the change and replace using the Mysql Update command like this:-

UPDATE thread SET data = replace(data,“SEARCH”,“REPLACE/WITH”) ;

I really hope to get help , and if it not impossible please try to help me with a php code which do it using preg_match.

Thank you a lot .

Zi5