Mysql MidString

Mysql MidString is used to return the string, with sub string beginning at position pos and len.

Mysql MidString

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)