select * where anyfield in anytable=$SEARCHFOR

Hi,
What is the easiest way to do a search like this:
select * where anyfield in anytable in {tab1,tab2,tab3,tab4,tab5}=$SEARCHFOR
?

Regards,
Talthen