deleting from tables an embedded url in words

[Blackhorse]

Hello,

I find that there is a site was using autolink , so many words in our forum refers to that site. How could I remove that embedded url from database? << It is like this in forum topics. even embedded in smilies.

it has more than 1500 queris in the database.

How could I just ask mysql to delete any embedded url for that site only?

because I am doing it manually and it is time wasting with alot of work.

Thanx

[glennrocksvb]

How did the links got there in the first place? If you delete them in the database, new links might get posted back again later.

Why not just hide them via CSS?

a[href^="https://www.domain.com"] {
    display: none !important;
}

Replace www.domain.com with the correct domain.

[Blackhorse]

How did the links got there in the first place? If you delete them in the database, new links might get posted back again later.

Why not just hide them via CSS?

a[href^="https://www.domain.com"] {
display: none !important;
}

Replace www.domain.com with the correct domain.

This code is good, but will hide some links from that site which is legal and important, (those that are not embededd).

I want only to remove the hidden ones, many users used to edit and write their posts in that site for its rich editor at that time, then come paste it organized on ours. In that site they made that trick for populating their sites through embedded links in every word. I just noticed while I am cleaning the site and reviewing the pictures. So it won't come back and even if, 10 or eben 50 urls accepted, but not thousands!.

[glennrocksvb]

Can you show me a sample of embedded and not embedded?

[Blackhorse]

Yes sure, I will send You a message (p.m)