xxxxxxxxxx
SELECT DISTINCT
select_list
FROM
table_name
WHERE
search_condition
ORDER BY
sort_expression;
Chances are you're looking for a GROUP BY:
xxxxxxxxxx
select *
from table
group by yourField
where yourField could be custom, like a CONCAT(field1, field2)