Original query : http://data.stackexchange.com/stackoverflow/s/1638/seek-and-destroy-spam-spam-urls-spam-baked-beans-and-spam Here is a version with the Url displayed, filter on the reputation users
Q&A for amateur radio enthusiasts
select top 100 SUBSTRING ( posts.body, CHARINDEX('HTTP://', UPPER(posts.body)) + 7, len(posts.body) ) as urlBody , posts.id as pid , users.id as uid from posts inner join users on posts.owneruserid = users.id where UPPER(posts.body) like '%HTTP://%' -- that contain a URL and users.reputation < 1000 -- skip high reputation users