SITE SEARCH
SITE LINKS
- SQL Basic
- SQL HOME
- SQL Intro
- SQL Syntax
- SQL Select
- SQL Distinct
- SQLWhere
- SQL And & Or
- SQL Order By
- SQL Insert
- SQL Update
- SQL Delete
- SQL Advanced
- SQL Top
- SQL Like
- SQL Wildcards
- SQL In
- SQL Between
- SQL Alias
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL functions
- SQL Functions
- SQL avg()
- SQL count()
- SQL first()
- SQL last()
- SQL max()
- SQL min()
- SQL sum()
- SQL Group By
- SQL Having
- SQL ucase()
- SQL lcase()
- SQL mid()
- SQL len()
- SQL round()
- SQL now()
- SQL format()
user login New user? Register Here | Forgot Password?
The MID() FunctionThe MID() function is used to extract characters from a text field. SQL MID() Syntax
SQL MID() ExampleWe have the following "Persons" table:
Now we want to extract the first four characters of the "City" column above. We use the following SELECT statement:
The result-set will look like this:
| ||||||||||||||||||||||||||||||||||||||||||