MYSQL在两列中选择DISTINCT值

非常邪恶和邪恶：

select distinct    least(foo, bar) as value1  , greatest(foo, bar) as value2from table