select column1,colum2 
from table1 
where column1 = 'bob'