Mysql MidString is used to return the string, with sub string beginning at position pos and len. This is a synonym for SUB STRING( str , pos , len ).
Understand with Example
The Tutorial illustrate an example from 'Mysql MidSTRING'. To understand this example we use the given below syntax that return the string begins with position 1 and length 9.
mysql> select mid('Roseindia.net',1,9)as MIDSTRING;
+-----------+ | MIDSTRING | +-----------+ | Roseindia | +-----------+ 1 row in set (0.00 sec)
Posted on: January 17, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles