MySQL SQL

MySQL SELECT DISTINCT

Return unique values instead of duplicate result rows.

Remove duplicates

SELECT DISTINCT category
FROM products;

MySQL compares all selected columns together when deciding whether rows are duplicates.