Take the search input into a variable and execute select query on click on Search button.
eg. String input ="abc";
Your query will look like :
String SqlQuery = "Select * from TableName where firstName like '%"+ input + "%' or lastName like '%"+ input + "%' or Location like '%"+ input + "%'";