select * from twoja_tabela where dupsko_i_pupsko='ass';

select * from twoja_tabela where dupsko_i_pukso=(select dupsko_i_pupsko from twoja_tabela where kolumna_1 = 'CIPA');