minte9
SoftwareDevelopment / MYSQL





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






Questions and answers:
Clink on Option to Answer




1. How do you search an interval?

  • a) WHERE id {{BETWEEN}} 1 AND 10
  • b) WHERE id {{BETWEEN}} (1, 10)

2. Find position

  • a) SELECT {{FIND_IN_SET}}('b','a,b,c,d'); //2
  • b) SELECT 'b' {{BETWEEN}} ('a,b,c,d'); //2


References: