queries

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%';