# Simple MySql question

**URL:** <https://forum.kirupa.com/t/simple-mysql-question/190856>\
**Category:** Uncategorized\
**Created:** [June 15, 2006, 3:47am UTC](https://forum.kirupa.com/t/simple-mysql-question/190856 "2006-06-15T03:47:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sigepmest37](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@sigepmest37](https://forum.kirupa.com/u/sigepmest37)\
**Post date:** [June 15, 2006, 3:47am UTC](https://forum.kirupa.com/t/simple-mysql-question/190856/1 "2006-06-15T03:47:50Z")

</div>

I have a table named ‘guestlist’ with 3 columns:

First  
Last  
Date

I want to run a query which gives me all the DIFFERENT dates in the date column.

For example if my dates column contains:

6/28/06  
6/28/06  
6/28/06  
6/29/06  
6/29/06  
6/30/06

I want it to only return 3 records:

6/28/06  
6/29/06  
6/30/06

How do i do it?

Thanks