How to extract specific information from a database field?

Question

CMS

<?php echo $field['handler']->setItem($item)->parseTeaser($item[$field['name']]);?>

This piece of code displays a link immediately in the 'a' tag How to extract from the field what exactly is url_key in the picture without the 'a' tag. I did not find the documentation, why is this problematic for instantcms. Naturally, not only one record is displayed, but several, which have different paths and line lengths.
<a href="/files/download/11/e0ab03d8">Скачать</a>

Answer 1

Perhaps the MySQL gurus will be able to give you a solution with a query...
But here's a solution with PHP:

$text = '<a href="/files/download/11/e0ab03d8">Скачать</a>';
preg_replace("'<[\/\!]*?[^<>]*?>'si", null, $text);
echo $text; // вернет Скачать

Regular expression clears string from html tags

Answer 2

Guys this is YAML