Which do you think is better, DISTINCT or GROUP BY?
SELECT DISTINCT id FROM phrase WHERE campaign LIKE 'proper%'
or
SELECT id FROM phrase WHERE campaign LIKE 'proper%' GROUP BY advert_id
I've asked this question before and received the following answer from a reliable source: "When there's just one column it doesn't matter". Do you agree?