A dalsi reseni od ChatGPT:

Dotaz:

code MySQL. I need remove begin and end html tag from table Slovnik field Pojem and let only text inside tag. Tags are always same
<a href="bibliografie.php?id=46">test inside tag</a>

UPDATE Slovnik
SET Pojem = TRIM(BOTH '<a href="bibliografie.php?id=46">' FROM SUBSTRING_INDEX(SUBSTRING_INDEX(Pojem, '</a>', 1), '>', -1));