maybe something like:

select distinct some_col from table1 .. <what you had before>

and use selectcol_arrayref.

you can push or unshift 'apple' onto front or back of results then, if you really want em there.

apologize in advance if above is a MySQL-ism.