Skip to content

Instantly share code, notes, and snippets.

@oneeyedman
Last active June 5, 2023 18:49
Show Gist options
  • Save oneeyedman/edf8c629a22ae9377aa61b42878c5937 to your computer and use it in GitHub Desktop.
Save oneeyedman/edf8c629a22ae9377aa61b42878c5937 to your computer and use it in GitHub Desktop.
SELECT `wp_comments`.*, `wp_comments`.`comment_content`, `wp_comments`.`comment_approved`
FROM `wp_comments`
WHERE `wp_comments`.`comment_content` LIKE '%porno%' AND `wp_comments`.`comment_approved` = '1';
SELECT `wp_comments`.*, `wp_comments`.`comment_author_url`, `wp_comments`.`comment_content`, `wp_comments`.`comment_approved`
FROM `wp_comments`
WHERE `wp_comments`.`comment_author_url` LIKE '%http%' OR `wp_comments`.`comment_content` LIKE '%http%' AND `wp_comments`.`comment_approved` = '1';
SELECT DISTINCT `wp_comments`. `comment_author_url`
FROM `wp_comments`
WHERE `wp_comments`.`comment_author_url` LIKE '%http%' AND `wp_comments`.`comment_approved` = '1';
SELECT `wp_comments`.*, `wp_comments`.`comment_content`, `wp_comments`.`comment_approved`, `wp_comments`.`comment_content`
FROM `wp_comments`
WHERE `wp_comments`.`comment_content` LIKE '%http%' AND `wp_comments`.`comment_approved` = '1' OR `wp_comments`.`comment_content` LIKE '%www%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment