searching a row from a database

is there anyway i can search for a particular row in all columns in a database and display them accordingly?

like in a customer table, i have CustomerID, Name, Address

is it possible to search for all the details of a customer?