Rude Word Counter

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

CREATE TABLE #RWL
(
RW VARCHAR(255),
)
GO


INSERT INTO #RWL(RW) VALUES('%arse%');


INSERT INTO #RWL(RW) VALUES('%balls%');
INSERT INTO #RWL(RW) VALUES('%bastard%');
INSERT INTO #RWL(RW) VALUES('%bitch%');

INSERT INTO #RWL(RW) VALUES('%bloody%');
INSERT INTO #RWL(RW) VALUES('%blowjob%');
INSERT INTO #RWL(RW) VALUES('%bollock%');

INSERT INTO #RWL(RW) VALUES('%boner%');
INSERT INTO #RWL(RW) VALUES('%boob%');
INSERT INTO #RWL(RW) VALUES('%bugger%');





INSERT INTO #RWL(RW) VALUES('%cock%');
INSERT INTO #RWL(RW) VALUES('%crap%');
INSERT INTO #RWL(RW) VALUES('%cunt%');
INSERT INTO #RWL(RW) VALUES('%damn%');
INSERT INTO #RWL(RW) VALUES('%dick%');





Select id as [Post Link], score 
from posts
join #RWL
on posts.body like #RWL.RW COLLATE database_default;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results