Patrick Patrick - 6 months ago 9
MySQL Question

Returning all values without duplicates in MySQL

I'm trying to return all the possible values in a table, but without duplicate values.

SELECT * FROM optional_hardware;


Is there any other way I can return all values without duplicate values?

Answer

Use the DISTINCT keyword

SELECT DISTINCT column FROM optional_hardware;