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 =======================