SQL MID()
Function
MID() Function
The MID() function is used to extract characters from a text field.
SQL MID() Syntax
Parameter | Description |
---|---|
column_name | Required. The field from which to extract characters. |
start | Required. Specifies the starting position (the starting value is 1). |
length | Optional. The number of characters to return. If omitted, the MID() function returns the remaining text. |
Demonstration Database
In this tutorial, we will use the tutorialpro sample database.
Below is the data from the "Websites" table:
+----+--------------+---------------------------+-------+---------+
| id | name | url | alexa | country |
+----+--------------+---------------------------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | Taobao | https://www.taobao.com/ | 13 | CN |
| 3 | tutorialpro.org | http://www.tutorialpro.org/ | 4689 | CN |
| 4 | Weibo | http://weibo.com/ | 20 | CN |
| 5 | Facebook | https://www.facebook.com/ | 3 | USA |
| 7 | Stackoverflow | http://stackoverflow.com/ | 0 | IND |
+----+---------------+---------------------------+-------+---------+
SQL MID() Example
The following SQL statement extracts the first 4 characters from the "name" column of the "Websites" table:
Example
Executing the above SQL produces the following output: