mysql IN 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',...);

Example 4: mysql like in

SELECT * from fiberbox where field REGEXP '1740|1938|1940';

Example 5: MYSQL

GRANT CREATE ON *.* TO 'testuser'@'localhost';