item1  perl
item2  python
item3  ruby
item4  php"

##</code><code>##

SELECT concat('item1 ', item1) FROM basket WHERE item LIKE 'a%'
 UNION 
SELECT concat('item2 ', item2) FROM basket WHERE item2 LIKE 'a%'
 ORDER BY 1

##</code><code>##

SELECT 'item1 ' || item1 FROM basket WHERE item LIKE 'a%'
 UNION 
SELECT 'item2 ' || item2 FROM basket WHERE item2 LIKE 'a%'
 ORDER BY 1