Between

 
SELECT 2 BETWEEN 1 AND 3, 1 BETWEEN 2 AND 3; // 1, 0

Get duplicates

 
SELECT *, COUNT(video_id) FROM video_thumb GROUP BY video_id HAVING ( COUNT(video_id) > 1 );

Find tables by column name

 
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('myphone') AND TABLE_SCHEMA='mydb';

// output: mytable

Find position in array

 
SELECT FIND_IN_SET('b','a,b,c,d'); //2




References: