Substring MySQL

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html

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'

mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', 2);
      -> 'www.mysql'
mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', -2);
      -> 'mysql.com'