list mysql code example

Example 1: mysql list databases

SHOW DATABASES;

Example 2: mysql is in list

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

Example 3: how to see database in mysql command line

use DBNAME;