Sherlock Group

There is some query that can be useful ::

1. SUBSTRING(str,pos) , SUBSTRING(str FROM pos) , SUBSTRING(str,pos,len) , SUBSTRING(str FROM pos FOR len)
   mysql> SELECT SUBSTRING(’Quadratically’,5);
   -> ‘ratically’
   mysql> SELECT SUBSTRING(’foobarbar’ FROM 4);
   -> ‘barbar’

   mysql> SELECT SUBSTRING(’Quadratically’,5,6);
   -> ‘ratica’
   mysql> SELECT SUBSTRING(’Sakila’, -3);
   -> ‘ila’
   mysql> SELECT SUBSTRING(’Sakila’, -5, 3);
   -> ‘aki’
   mysql> SELECT SUBSTRING(’Sakila’ FROM -4 FOR 2);
   -> ‘ki’

2. SUBSTRING_INDEX(str,delim,count)
   mysql> SELECT SUBSTRING_INDEX(’www.mysql.com’, ‘.’, 2);
   -> ‘www.mysql’
   mysql> SELECT SUBSTRING_INDEX(’www.mysql.com’, ‘.’, -2);
   -> ‘mysql.com’
3. TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str) , TRIM(remstr FROM] str)
   mysql> SELECT TRIM(’ bar ‘);
   -> ‘bar’
   mysql> SELECT TRIM(LEADING ‘x’ FROM ‘xxxbarxxx’);
   -> ‘barxxx’
   mysql> SELECT TRIM(BOTH ‘x’ FROM ‘xxxbarxxx’);
   -> ‘bar’
   mysql> SELECT TRIM(TRAILING ‘xyz’ FROM ‘barxxyz’);
   -> ‘barx’
4. mysql> SELECT 1+’1′;
   -> 2
5. mysql> SELECT CONCAT(2,’ test’);
   -> ‘2 test’
6. mysql> SELECT RAND();
   -> 0.9233482386203
   mysql> SELECT RAND(20);
   -> 0.15888261251047
   mysql> SELECT RAND(20);
   -> 0.15888261251047
   mysql> SELECT RAND();
   -> 0.63553050033332
   mysql> SELECT RAND();
   -> 0.70100469486881
7. mysql> SELECT something FROM tbl_name
   -> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;