Mysql和PHP更正查询语法

Question

I am trying to get this query to only display 1 result (not LIMIT) in this example:

SELECT company_id  FROM `location` WHERE `state` = 'XX'

It results are similar to this:

16 9 9 9 9 30 30 30 45 50 50 50 50 57 7 79 80 80 80 80 120 120 120 120 120 128 131 120 265 265

I am aiming for these results:

16 9 30 45 50 57 7 79 80 120 128 131 120 265

Answer 1

Just add DISTINCT keyword before you column name

SELECT DISTINCT company_id FROM `location` WHERE `state` = 'XX'

The DISTINCT keyword in a SELECT statement removes duplicates returned by a query.