Advanced MySQL Search & Replace

Removing the second instance of string in column

[Eric_Lander]

I'm working on a site right now that's using WordPress, and for some reason -- all posts have additional instances of "<-- more -->"

Using PHPMyAdmin, I'm planning to strip out all but the first instance of this string.

Is there any way this be done?

[coopster]

Will the REPLACE [dev.mysql.com] function work for you?