cruelity93 — 2011-03-07T08:55:02-05:00 — #1
I got for example this :
id url status
1 google.com down
2 ask.com up
3 monkey.nl 404
4 noob.com up
5 hello.com down
How would I for example delete all sites that got the status down?
So I wanna keep all up sites the rest gone, or the ones with 404 gone or ones with down gone.
r937 — 2011-03-07T09:20:42-05:00 — #2
WHERE status IN ( 'down' , '404' )
cruelity93 — 2011-03-07T09:24:35-05:00 — #3
all my dead shells gone