MySQL SELECT仅匹配字符串查询

有成千上万的记录,

例如:

SELECT id, body FROM topics WHERE body LIKE '%the_url\/article_detail.php%'.

1668955,    bunch of text</figcaption><br /><a href="https://the_url/article_detail.php?article_id=10003414" target="_blank">w..... </a><br /><h2> text ....<br /><br /><a href="https://the_url/article_detail.php?article_id=10002526" target="_blank">...... text .....

Is there a way to get only the IDs and the URLs like https://the_url/article_detail.php?article_id=10003414 https://the_url/article_detail.php?article_id=10002526 ?

评论