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:-
http://www.siteurl.com/foum/صور-كوميدية-256/تعريف-هام-للحب-بالصور-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