admin管理员组

文章数量:1122846

We have many forms that are hosted externally from our Wordpress environment that we are moving to a different system, so we'd like to generate a list of the pages that contain these links along with the list of links themselves.

From phpmyadmin, I can get the list of pages that include the forms with a simple query like this:

select guid from wp_2_posts where post_content LIKE '%ourformdomain%';

Is it possible in the same query to include a concatenated list of the URLs of the embedded forms themselves on each of those pages? I think I'd want to use GROUP_CONCAT for that, but I'm not sure how the subquery can get the URLs themselves for the page in the query.

I'm hoping to avoid PHP code for this - as it needs to be run in several Wordpress installs.

Thank you for the help.

本文标签： is it possible to get a list of URLs from postcontent directly in a mysql query via phpadmin

版权声明：本文标题：is it possible to get a list of URLs from post_content directly in a mysql query via phpadmin? 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736304184a1932144.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。