SQL Mid()Posted On: February 28, 2016
The MID() is used to extract characters from a text field.
SELECT MID(column_name,start,length) AS some_name FROM table_name;
The subsequent SQL selects the first three characters from the “City” column from the “Visitors” table:-
SELECT MID(City,1,3) AS ShortCity FROM Visitors;