SQL MID()
SQL MID() Function
MID() Function
MID() function is used to extract from a text field character.
SQL MID() syntax
SELECT MID(column_name,start[,length]) FROM table_name;
| Parameters | Description |
|---|---|
| column_name | Required. The field from which characters are to be extracted. |
| start | Required. Specifies the starting position (starting value is 1). |
| length | Optional. The number of characters to return. If omitted, the MID() function returns the remaining text. |
Demo Database
In this tutorial, we will use the php sample database.
The following is the data selected from the "Websites" table:
+----+--------------+--- ------------------------+------+---------+
| id | name | url --------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | Taobao | https://www.taobao.com/ | 13 | CN |
| 3 | php Chinese website | http://www.php.cn/ | 4689 | CN |
| 4 | Weibo | http://weibo.com/ | 20 | CN |
| 5 | Facebook | https://www.facebook.com/ | 3 | USA |
| 7 | stackoverflow | http://stackoverflow.com/ | 0 | IND |
+----+---------------+----------- ----------------+-------+---------+
| id | name | url --------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | Taobao | https://www.taobao.com/ | 13 | CN |
| 3 | php Chinese website | http://www.php.cn/ | 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( ) ExampleThe following SQL statement extracts the first 4 characters from the "name" column of the "Websites" table:
ExampleSELECT MID(name, 1,4) AS ShortTitle
##FROM Websites;
Execute the above SQL and the output result is as follows:
