SQL MID() Function
The MID() Function
The MID() function is used to extract characters from a text field.
SQL MID() Syntax
| SELECT MID(column_name,start[,length]) FROM table_name |
| Parameter |
Description |
| column_name |
Required. The field to extract characters from |
| start |
Required. Specifies the starting position (starts at 1) |
| length |
Optional. The number of characters to return. If
omitted, the MID() function returns the rest of the text |
SQL MID() Example
We have the following "Persons" table:
| P_Id |
LastName |
FirstName |
Address |
City |
| 1 |
Hansen |
Ola |
Timoteivn 10 |
Sandnes |
| 2 |
Svendson |
Tove |
Borgvn 23 |
Sandnes |
| 3 |
Pettersen |
Kari |
Storgt 20 |
Stavanger |
Now we want to extract the first four characters of the "City" column above.
We use the following SELECT statement:
| SELECT MID(City,1,4) as SmallCity FROM Persons |
The result-set will look like this:
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
| 
