mysql in statement code example

Example 1: mysql query where in

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

Example 2: mysql is in list

SELECT 
    column1,column2,...
FROM
    table_name
WHERE 
	(expr|column_1) IN ('value1','value2',...);

Example 3: mysql in

SELECT 
    column1,column2,...
FROM
    table_name
WHERE 
    column1 IN ('value1','value2',...);

Tags:

Php Example

Related