Select query help!!!

[Select query help!!!]

Hi people,
how to extract the following:
subnet2 address1
subnet2 address2
subnet2 address3
subnet2 address4
subnet2 address5

from this table

column1 | column2
--------------------
subnet1 address1
subnet1 address1
subnet2 address1
subnet2 address2
subnet2 address3
subnet2 address4
subnet2 address5

Thanks a lot,

Serg

 

[Tonín]

SELECT *
FROM YourTable
WHERE column1="subnet2";


Tonín