MySQL DISTINCT to Remove Duplicate Listing

How to select and display records from MySQL table using the DISTINCT keyword for unique data.

This is for removing duplicated results in order to gain unique listings from
your database table using the DISTINCT keyword in your
MySQL select statement .

For example if you ran this:

Select Cars FROM Cars_Listing
======== Results =======
BMW
BMW
HONDA
BENZ
BENZ
BMW
FORD
FORD
=======================

Notice how there is more then one BMW.

Here is how to clean up that result by using the DISTINCT keyword in your
MySQL select statement

Select DISTINCT Cars FROM Cars_Listing
======== Results =======
BMW
HONDA
BENZ
FORD
=======================
Tagged : / / / / /

4 thoughts on “MySQL DISTINCT to Remove Duplicate Listing

Leave a Reply

Your email address will not be published. Required fields are marked *