Easy Tutorial
❮ Sql Having Sql Between ❯

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:

❮ Sql Having Sql Between ❯