Query Operators

A 'query' is a database term. You extract or modify data by running a query.

To create the query you need to use some standard SQL database command words along with 'query operators'.

The SQL database commands describe the basic operation to be carried out such as INSERT, UPDATE, SELECT

And the 'query operators' reduce the numbers of records being handled in some way.

For example

= (Equals) means the condition has to be equal to something

e.g. SELECT * FROM Customer WHERE CustomerID = 'HJONES'

would extract all records (the * bit)from the Customer table as long as the CustomerID matches 'HJONES'

Other query operators are (there are many others)

> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
NOT - finds records that do not meet the condition
OR - finds records that match one condition OR another.

2020-10