cannot get rid of duplicate values

Question

I have following table in my database: enter image description here

All I need is to load Country list for User with ID=5:

Then, when I will click for example on USA, it will load the cities for that country:

I can display country field for every row where User ID=5 but I will have the following result which is not acceptable.

Are there any tricks which can help me not to duplicate country values?

Perhaps something like this: `SELECT DISTINCT Country FROM WHERE UserID = 5;` http://www.mysqltutorial.org/mysql-distinct.aspx — Cyclonecode, Aug 03 '14 at 05:43

score 2 · Accepted Answer · answered Aug 03 '14 at 05:45

2

You should be able to use DISTINCT to remove duplicate values from your resultset:

SELECT DISTINCT Country FROM <table> WHERE UserID = 5;

answered Aug 03 '14 at 05:45

Cyclonecode

score 1 · Answer 2 · answered Aug 03 '14 at 05:52

1

As Krister says, part 1 is

SELECT DISTINCT COUNTRY FROM TABLE WHERE USERID =5

Then to get cities for that user in USA:

SELECT CITY FROM TABLE WHERE USERID =5 AND COUNTRY = 'USA'

answered Aug 03 '14 at 05:52

Avner

2 Answers2