sql query for displaying two columns where last name and first name are in where clause for php code example

Example: MySQL WHERE

SELECT 
    select_list
FROM
    table_name
WHERE
    search_condition;
    AND OR Like In Is
    officeCode = 1;