Colgate-Palmolive interview question

How to search a table for a particular entry? (SQL)