Mysql Order

[hmunawer]

Hi There
Could you give me the order to be executed in MySQL so as to redirect links from an old domain to a new domain such as the link

http://www.m59m.com/vb/mwaextraedit6/extra/04.gif

to be directed to

http://www.alabbady.com/vb/mwaextraedit6/extra/04.gif

By using MySQL order

Best Regards

[ahmed-samara]

This is the replacement


UPDATE post SET pagetext = REPLACE(pagetext,'http://www.m59m.com/vb/mwaextraedit6/extra/04.gif','http://www.alabbady.com/vb/mwaextraedit6/extra/04.gif');

http://www.m59m.com/vb/mwaextraedit6/extra/04.gif = The old

http://www.alabbady.com/vb/mwaextraedit6/extra/04.gif = The New

[hmunawer]

It works man

Thank you very much

[ahmed-samara]

Thank you for your reply :)