select where in mysql code example

Example 1: mysql query where in

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

Example 2: select mysql

SELECT column_name(s) FROM table_name

Example 3: select where mysql

SELECT 
    select_list
FROM
    table_name
WHERE
    search_condition;

Example 4: MySQL WHERE

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

Tags:

Php Example

Related