scriptor+2008-08-09 01:38:15--

Code: (dl )

1
2
3
4
5
6

SELECT username 
FROM tabelle 
WHERE 
attribute != 'type' 
OR 
( attribute = 'type'  AND value != 'reject' )

1
2
3
4
5
6
7
8
9

+----------+
| username |
+----------+
| esskar   | 
| esskar   | 
| foo      | 
| foo      | 
| bar      | 
+----------+

Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. -- Damian Conway in "Perl Best Practices"
lesen: Wie frage ich & perlintro brian's Leitfaden für jedes Perl-Problem