my $sql = qq{ SELECT item1 FROM basket WHERE item LIKE 'a%' UNION SELECT item2 FROM basket WHERE item2 LIKE 'a%' UNION SELECT item3 FROM basket WHERE item3 LIKE 'a%' UNION SELECT item4 FROM basket WHERE item4 LIKE 'a%' ORDER BY 1 };