Contents
SQL MID Function: Main Tips
- This function is needed to take out characters from a data record field.
- There are function equivalents for other database-systems.
Syntax of SQL MID
Example
SELECT MID(col_name,start,length) AS se_name FROM tbl_name;| Parameters | Descriptions |
|---|---|
| col_name | Needed. The data record to take out characters. |
| start | Needed. Defines the start position. |
| length | May use. The amount of characters to bring. |
The SUBSTRING() function in SQL Server:
Example
SELECT SUBSTRING(column_name,start,length) AS some_name FROM table_name;The SUBSTR() function in Oracle:
Example
SELECT SUBSTR(column_name,start,length) AS some_name FROM table_name;Demo Database
The table called" Customers":
| ID | Name | Name | City |
|---|---|---|---|
| 1 | Ben Choplinks | Ben Choplink | London |
| 2 | Donald Rich | Donald Richario | Talinn |
| 3 | Lilly Smilkins | Lilly Smilkin | Frankfurt |
| 4 | Brandinina | Tom Hitchins | Dublin |
| 5 | Carizmos | Christiano Kerrys | Paris |
SQL MID: Example
In the ode example below picks out the primary four data records from the column "City" in the table "Customers":
Example
SELECT MID(City,1,4) AS ShortCity FROM Customers;