MySQL查询内容UP TO某个字符串和AFTER相同的字符串

Question

In a query result, I want to store everything leading UP TO a certain string, the </a> in <a href="imgpath" imgsrc="imgpath"></a> and then everything AFTER the </a> to a second variable.

[edit] a rephrasing of the question:

the value in $row[post_content] would be something like "<ahref=''><image></a><p>copy</p>" ...

i need to split this into $val1 = "<ahref=''><image></a>"; and $val2 = "<p>copy</p>";

This is probably done with substr()? but i have no idea how, and I HAVE searched, and found nothing but references to bad character sets in mysql because of my use of the term 'character' in my search.

Answer 1

$tmp = explode('</a>', $yourStr);
print_r($tmp);

You tagged your question with mysql, so Bohemian gave you answer using mysql. Please use correct tags and description to get right answer.