pgsql2shp

Hi all
I am developing application Web use Mapserver and Database Postgis
I want Export Data Corrdinate in Post Gis to shapfile. But Export with condition
ex: select * from Province where id in '1,2,3,4,67,34,23,22'
or with
ex: Select with Box or with corrdinate spatial (2945845 45958383, 39359459 2342345345, 234823488 4548848, 334834838 85885685) corrdinate is illustrate
How can i do that ???
Show me 3 ways.