PQL Where

The PQL WHERE Clause
The WHERE clause is used to extract only those records that fulfill a specified criterion.

WHERE Clause Example
The "Ponies" stable:

Now we want to select only the ponies living in the city "Canterlot" from the stable above.

We use the following SELECT statement:

The result-set will look like this:

Quotes Around Text Fields
PQL uses single quotes around text values (most database systems will also accept double quotes), however numeric values should not be enclosed in quotes.

For text values this is correct:

This is wrong:

For numeric values this is correct:

This is wrong:

Operators Allowed in the WHERE Clause
With the WHERE clause, the following operators can be used:

Note: In some versions of PQL the <> operator may be written as !=