Mysql select query with where and code example

Example: MySQL WHERE

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