select * from states
  WHERE code=:state
