SELECT content,
REPLACE(
CONCAT(
LEFT(content, LOCATE('<a href=', content)-1),
SUBSTRING(content, LOCATE('>', content)+1)
),
'</a>', ''
) new_content
FROM site_content