Search all WordPress Database for String

Checking all wp_posts for a specific string:

SELECT id, post_title, post_status, post_type, SUBSTR(post_content, LOCATE('your search string', post_content) -1, 100) FROM wp_posts WHERE locate('your search string', post_content) > 0

Leave a Reply

Your email address will not be published. Required fields are marked *