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

http://www.siteurl.com/foum/%D8%B5%D...8F-309560.html



Explain:-

http://www.siteurl.com/foum/%D8%B5%D...-THREADID.html





Change With:-

http://www.siteurl.com/foum/showthread.php?t=309560

Explain:-

http://www.siteurl.com/foum/showthread.php?t=THREADID



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