[BenniG.]

Du könntest ein UNION versuchen:

SELECT * FROM t1
WHERE ( t1.c2 = 1 ) 
union
select * from t1
where ( t1.c3 = 'test' ) 
union 
select * from t1
where ( t1.c2 = 2 )

Oder alternativ ein order by:

SELECT * FROM t1
WHERE ( t1.c2 = 1 ) OR ( t1.c3 = 'test' ) OR ( t1.c2 = 2 )
order by 
   case when ( t1.c2 = 1 ) then 1 
   when ( t1.c3 = 'test' ) then 2
   when ( t1.c2 = 2 ) then 3
   else 4
   end