regex anybody ?

hello boys & girls
anybody is good with regex commands to help me & "save me eyes" from individually work

i wanted to bulk remove all links from a specific domain in my website from all posts & made a mistake with no backup for it
i used search and replace plugin to remove the specific domain but the stupid me typed only the domain with no sintax so i have left from for example

Code:

---

https://google.com/JQ92VZeL.html

---

with <a href="JQ92VZeL">JQ92VZeL</a> on all links

it's any syntax to bulk remove the second part from the links considering that those numbers left are random for ex
from

Code:

---

https://google.com/JQ92VZeL.html

---

left with

Code:

---

JQ92VZeL.html

---

Code:

---

https://google.com/JQ93V555.html

---

left with

Code:

---

/JQ93V555.html

---

and so on

without deleting from each post manually

As a general rule, you should never parse or manipulate HTML using regexps. But let's ignore that and try to salvage this situation. I don't understand exactly what you need to remove, though...

Quote:

---

<a href="JQ92VZeL">JQ92VZeL</a>

---

These would be matched by \<a href\=\"[a-zA-Z0-9]{8}\"\>[a-zA-Z0-9]{8}\<\/a\>

Quote:

---

/JQ93V555.html

---

These would be matched by \/[a-zA-Z0-9]{8}\.html

In principle, replace all matches for whichever of the above applies with nothing. The expressions may need tweaking depending on the possible lengths and characters of these random strings. Try everything on an offline copy first.

Quote:

---

DRY RUN: 170 tables were searched, 0 cells were found that need to be updated, and 0 changes were made.

---

it can't find the links like the first time when i have tried

Quote:

---

I don't understand exactly what you need to remove, though...

---

let's take for example a filehost like uploaded.net

when you post links for download in your wordpress or forum links are as follow

Quote:

---

https://uploaded.net/snvursmtf74p or https://uploaded.net/2jxOGGlq or https://uploaded.net/avl4rgimqa1c/Hypnography.rar.html

---

what i did by mistake was putting only the uploaded.net in command do be bulk deleted
so i I am left with the last part of the links,(the part without the domain name) which is different
snvursmtf74p , 2jxOGGlq,Hypnography that part i want to bulk delete from all post if it's posible

Quote:

---

snvursmtf74p

---

[a-z0-9]{12}

Quote:

---

2jxOGGlq

---

[a-zA-Z0-9]{8}

Quote:

---

Hypnography.rar.html

---

.*\.[a-z]{3}\.html$

For all of these, you can add \/ at the beginning to match leading slashes. If you send me a PM with some more specific examples of what you need to replace as shown in your editor, we can determine if the expressions need further tweaking.