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)

Mysql MidString

Mysql MidString

Mysql MidString

Tutorials