[an error occurred while processing this directive]

Mysql MidString

                         

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 ). 

SYNTAX:-MID(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.

 

 

 

Query:

mysql> select mid('Roseindia.net',1,9)as MIDSTRING;

Output:-

+-----------+
| MIDSTRING |
+-----------+
| Roseindia |
+-----------+
1 row in set (0.00 sec)

                         

[an error occurred while processing this directive]