Is it possible to list column entry only once? While this is not a huge deal, I'm just wondering if this is possible (I'm using MySQL in case that matters).

I have a query that returns something like this:

Basket      Contents
basket1     apple
basket1     orange
basket1     pear
basket2     lemon
basket2     banana
basket2     lime


Is it possible using only SQL to get this output?

Basket      Contents
basket1     apple
            orange
            pear
basket2     lemon
            banana
            lime


In other words, is it possible to list the column entry only once for each entry?  Thank you.
I would say this is easier on the representational layer but if you want it in pure MySQL this will do it:

set @current='';
select show_basket, content 
from (
    select case 
        when @current = basket 
            then '' 
            else basket 
        end as show_basket, 
        content, @current:=basket 
    from test_131547
    order by basket
) a;


Output:

+-------------+---------+
| show_basket | content |
+-------------+---------+
| 1           | lemon   |
|             | lime    |
|             | apple   |
|             | banana  |
| 2           | kiwi    |
|             | apple   |
|             | orange  |
+-------------+---------+