zebe Posted January 19, 2006 Share Posted January 19, 2006 Hi,I am creating a database system where I have a field that is called semester. The values will be similiar to Fall-05, Spring-06 etc. There will be multiple instances throughout all the student entries in the system. What I want to do is query the database to find all the different semesters that exist in the database, but I just need one of each, so I can run another query using these values to show semester totals. Is there a specific MySQL query that can do this operation?Thanks for your help! Quote Link to comment Share on other sites More sharing options...
Honoré Posted January 19, 2006 Share Posted January 19, 2006 [!--quoteo(post=338040:date=Jan 19 2006, 07:00 PM:name=zebe)--][div class=\'quotetop\']QUOTE(zebe @ Jan 19 2006, 07:00 PM) [snapback]338040[/snapback][/div][div class=\'quotemain\'][!--quotec--]Hi,I am creating a database system where I have a field that is called semester. The values will be similiar to Fall-05, Spring-06 etc. There will be multiple instances throughout all the student entries in the system. What I want to do is query the database to find all the different semesters that exist in the database, but I just need one of each, so I can run another query using these values to show semester totals. Is there a specific MySQL query that can do this operation?Thanks for your help![/quote]Try[code]SELECT DISTINCT semester FROM mytable;[/code] Quote Link to comment Share on other sites More sharing options...
zebe Posted January 19, 2006 Author Share Posted January 19, 2006 Perfect! Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.