mobile logo

MySQL select * with distinct id

Solution:

Try using GROUP BY:

  select id, city, state, zip
    from mytable
group by id

Note that this will return an arbitrary address for each id if there are duplicates.

Demo: http://www.sqlfiddle.com/#!2/c0eba/1