# SQL: dsitinct not working?

**URL:** <https://forum.kirupa.com/t/sql-dsitinct-not-working/178548>\
**Category:** programming\
**Created:** [February 11, 2006, 8:41pm UTC](https://forum.kirupa.com/t/sql-dsitinct-not-working/178548 "2006-02-11T20:41:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![FreakSheep](https://avatars.discourse-cdn.com/v4/letter/f/d9b06d/32.png) [@FreakSheep](https://forum.kirupa.com/u/FreakSheep)\
**Post date:** [February 11, 2006, 8:41pm UTC](https://forum.kirupa.com/t/sql-dsitinct-not-working/178548/1 "2006-02-11T20:41:53Z")

</div>

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