With Clause with regex

http://www.sql.ru/forum/921216/regexp-udalenie-podstroki-iz-stroki-mezhdu-dvumya-shablonami

https://dev.mysql.com/doc/refman/8.0/en/with.html

WITH cte1 AS (SELECT a, b FROM table1), cte2 AS (SELECT c, d FROM table2) SELECT b, d FROM cte1 JOIN cte2 WHERE cte1.a = cte2.c;

with s as(select '"select j.FIO \"Фамилия, Имя Отчество\", PERSON_ID \"ID человека\""' str from dual)
select str,
regexp_replace(str, '\\"[^\"]*\\"', '')
from s;

StellaMaris

SELECT a.title, a.fulltext FROM maris01.xx2sk_content a WHERE a.fulltext LIKE '%<!--58dba6d87ab6e1490790104-->%' OR a.fulltext LIKE '%<!--/58dba6d87ab6e1490790104-->%'
;