Ok, I need to get the DISTINCT file from a table, but ‘url.php’ can’t be in the returned rows.
Query: SELECT DISTINCT FILE FROM usersonline;
Returns:
/index.php
/url.php
And the query i’m having trouble with…
Query: SELECT DISTINCT FILE FROM usersonline WHERE FILE <> ‘/url.php’;
Returns: Empty Set.
I don’t get it! The WHERE FILE <> ‘/url.php’ should make MySQL return just /index.php
I might be making a stupid little mistake though… I dunno
Thanks,
_naaman
