phpMyAdmin从列中选择某些字符串

发布于 2025-02-09 14:01:43 字数 924 浏览 0 评论 0原文

我正在尝试仅选择以下longText值的a href URL部分（在wp_posts表和post_content列中），

Profonest Unique Hardware - <a href="https://bit.ly/_ADXTxn" target="_blank" rel="noopener">https://bit.ly/_ADXTxn</a>
Pandora Games 3D / Arcade: <a href="https://bit.ly/_AATHpd" target="_blank" rel="noopener">https://bit.ly/_AATHpd</a>
Wedoit Handhelds / Consoles:

所以我所需要的只是ahref

eg中的实际url： https://bit.ly/_adxtxn

有两个链接，如果可能的话，我想抓住这两个链接。

https://bit.ly/_adxtxn

https://bit.ly/_aathpd

我试图找到确切的端子来搜索解决方案，但是我猜是在post_content类样式查询的位置中搜索regex or;？

原文

I'm trying to select just the a href url portion of the following longtext value (in wp_posts table and post_content column)

Profonest Unique Hardware - <a href="https://bit.ly/_ADXTxn" target="_blank" rel="noopener">https://bit.ly/_ADXTxn</a>
Pandora Games 3D / Arcade: <a href="https://bit.ly/_AATHpd" target="_blank" rel="noopener">https://bit.ly/_AATHpd</a>
Wedoit Handhelds / Consoles:

So all I would need would be the actual URL in the ahref

eg: https://bit.ly/_ADXTxn located within this and not the link before closing the ahref

There are two links and I would like to grab both if possible.

https://bit.ly/_ADXTxn

https://bit.ly/_AATHpd

I've tried to get the exact terminolgy to search for a solution but I'm guessing regex or % in a WHERE post_content LIKE style query?

分享到QQ

分享到微博