SQL MID() Function
Submitted by admin on Monday, May 16, 2011 - 09:24.
The MID() function is used to extract values from a column. The MID() contain three (3) parameters. The first one is used to select which column to extract, the second one is the starting position, the last one is the number of characters to be extracted.
SQL MID() Syntax
Consider the following table for this exercise
Users
| Firstname | Lastname | Salary | DeptID |
|---|---|---|---|
| John | Smith | 1000 | 1 |
| Mathew | Simon | 3000 | 1 |
| Bill | Steve | 2200 | 1 |
| Amanda | Rogers | 1800 | 2 |
| Steve | Hills | 2800 | 2 |
| Steve | jobs | 2400 | 2 |
| bill | cosby | 700 | 3 |
Example # 1
This will extract the Firstname column from our table.
Result of the Query
| Firstname |
|---|
| JOH |
| MAT |
| BIL |
| AMA |
| STE |
| STE |
| BIL |
The result shows the first three (3) characters of the Firstname column.
You can also start the position to whatever you like.
Example # 2
This will extract the value of Firstname starting from 2.
| Firstname |
|---|
| ohn |
| ath |
| ill |
| man |
| tev |
| tev |
| ill |
Add new comment
- 338 views
