How to clean up these forums with 3 MySQL commands

[mojack]

Here's a few MySQL commands for BigPoppa, hopefully should remove about 500 members on here so we can all get back to civilized boxing conversations.

DELETE FROM members WHERE pac_fan = true
AND status = "nuthugger"
AND part-timer = true
AND delusional = true;

DELETE FROM members WHERE pavlik_fan = true
AND mood = "sour g****s"
AND excuses = true;

DELETE FROM member WHERE hopkins_fan = true
AND hopkins_bandwagon > 18-OCT-2008
AND boxing_knowledge = null;


If BigPoppa could run the queries asap, would much be appreciated.

[miron_lang]

Delete from members
where favorite_fighter = 'Pacquiao'

go

[miron_lang]

Here's a few MySQL commands for BigPoppa, hopefully should remove about 500 members on here so we can all get back to civilized boxing conversations.

DELETE FROM members WHERE pac_fan = true
AND status = "nuthugger"
AND part-timer = true
AND delusional = true;

DELETE FROM members WHERE pavlik_fan = true
AND mood = "sour g****s"
AND excuses = true;

DELETE FROM member WHERE hopkins_fan = true
AND hopkins_bandwagon > 18-OCT-2008
AND boxing_knowledge = null;


If BigPoppa could run the queries asap, would much be appreciated.

You dedicate 3 colums for 3 fighters. That means you have as many columns as there is fighters.


Very BAD Data Architecture

[mojack]

You could insert a foreign key or even just reference via ID, but if I did that nobody would understand the MYSQL query as they wouldn't be able to see the 'boxers' table. :P

[miron_lang]

You could insert a foreign key or even just reference via ID, but if I did that nobody would understand the MYSQL query as they wouldn't be able to see the 'boxers' table. :P

I understand

here's a more logical way of putting it. with the same readability for non SQL practioner.

DELETE FROM members WHERE favorite_fighter = 'Pacquiao'
AND fan_type = "nuthugger"
AND member_type = 'part-timer'
AND member_state = 'delusional' ;


DELETE FROM members WHERE favorite_fighter = 'Pavlik'
AND member_state = "sour g****s"
AND member_mood = 'excuses' ;

DELETE FROM member WHERE favorite_fighter = 'hopkins'
AND favorite_fighter_last_modified >= 18-OCT-2008
AND boxing_knowledge = null;

[Flab]

Did I just walk into a Star Wars convention?

[Castor_Troy]

its I.T you JMM nut lover

[WhoreUs]

Did I just walk into a Star Wars convention?

nope.

star trek.

[moochi]

MySQL....bring it on!!!!!!!

for a moment I thought I was in the wrong forum. Happy to see that there are some IT guys in here

[JoartCC]

Here's a few MySQL commands for BigPoppa, hopefully should remove about 500 members on here so we can all get back to civilized boxing conversations.

DELETE FROM members WHERE pac_fan = true
AND status = "nuthugger"
AND part-timer = true
AND delusional = true;

DELETE FROM members WHERE pavlik_fan = true
AND mood = "sour g****s"
AND excuses = true;

DELETE FROM member WHERE hopkins_fan = true
AND hopkins_bandwagon > 18-OCT-2008
AND boxing_knowledge = null;


If BigPoppa could run the queries asap, would much be appreciated.

Let's use common sense.

Trying to filter a structure by using automated pre-made laws which will govern trains of thought which branches on multiple avenues...

Is just a waste of time.

The best method would be to let things be...

Set hard rules on racism...

And be *******.

The red line of course would be racism and that's all there is to it.

It's foolish to use a program which will lay down automated guidelines and empower the same program to act with punitive authority.

Might as well kick out mods and the site owner.