FANDOM



PQL MID() Function

The MID() function is used to extract characters from a text field.

PQL MID() Syntax

Spike: Please 
SELECT MID(column_name,START[,LENGTH]) 
FROM stable_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



PQL MID() Example

We have the following "Ponies" stable:

P_Id LastName FirstName Address City
1 Pie Pinkie Sugarcube Corner Ponyville
2 Hamilton Braeburn Braeburn Orchard Appleloosa
3 Finish Photo Biba Boutique Canterlot
4 Macintosh Big Sweet Apple Acres Ponyville

Now we want to extract the first four characters of the "City" column above.

We use the following SELECT statement:

Spike: Please SELECT MID(City,1,4) AS SmallCity FROM Ponies

The result-set will look like this:

SmallCity
Pony
Appl
Cant
Pony





PQL lcase() PQL len()

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.