Would you like to get a list of all the different values in a column? Use the DISTINCT keyword. Here's an example:

mysql> select * from train;

+-------+--------+-------------+-----+

| time  | length | destination | tid |

+-------+--------+-------------+-----+

| 07:05 |      1 | Salisbury   |   1 |

| 08:18 |      2 | Swindon     |   2 |

| 09:05 |      2 | Southampton |   3 |

| 05:45 |      1 | Swindon     |   4 |

| 10:35 |     12 | Plymouth    |  10 |

| 13:49 |      2 | Swindon     |   6 |

| 14:20 |      2 | Salisbury   |   7 |

| 17:07 |      1 | Swindon     |   8 |

| 18:18 |      1 | Salisbury   |   9 |

| 13:00 |      6 | Windsor     |  11 |

+-------+--------+-------------+-----+

10 rows in set (0.04 sec)



mysql> select distinct destination from train;

+-------------+

| destination |

+-------------+

| Salisbury   |

| Swindon     |

| Southampton |

| Plymouth    |

| Windsor     |

+-------------+

5 rows in set (0.08 sec)



mysql> 

See More on SQL module.


(written 2005-04-14 07:13:19)

 S157 - More MySQL Commands

Back to Cover all the options

Previous and next or Horse's mouth home

Forward to Spotted - the local MP

Natural or man-made?
Short weekend
What they are saying about our OF COURSE newsletter
Spotted - the local MP
Getting a list of unique values from a MySQL column
Cover all the options
Fire drill
An apology to Mr Boneparte
See 8 but buy 6. See 6 but you can buy 8.
Our most popular resources
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33 at 50 posts per page


This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).