Training, Open Source computer languages

PerlPHPPythonMySQLhttpd / TomcatTclRubyJavaC and C++LinuxCSS

Search our site for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Getting a list of unique values from a MySQL column
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)

 
Associated topics are indexed under
S157 - More MySQL Commands

Back to
Cover all the options
Previous and next
or
Horse's mouth home
Forward to
Spotted - the local MP

Some other Articles
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
1633 posts, page by page
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).

© WELL HOUSE CONSULTANTS LTD., 2008: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho