SQL

mysql query where in

SELECT * FROM `tableName` WHERE `ColumnName` IN (1,2,3);

mysql query where in select

SELECT *
FROM some_table
WHERE relevant_field IN
(
    SELECT * FROM
    (
        SELECT relevant_field
        FROM some_table
        GROUP BY relevant_field
        HAVING COUNT(*) > 1
    ) AS subquery
)

MySQL WHERE

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

mysql where or where query

SELECT * FROM `tableName` WHERE `column_1` = 1 OR  `column_2` = 2;