Home    Back    Forward    Refresh    txtSQL Homepage

WHERE Syntax

WHERE ([Function(]column[)] Operator value[, ( AND | OR | XOR ) ])...

A where clause tells txtSQL what rows that you are looking for. Where clauses can be used in select(), delete() and update(). For more information on a lower-level implementation of WHERE clauses, see WHERE clauses.

For a list of possible operators, see relational operators



User Comments - WHERE Syntax
No comments posted yet;
Last Page Next Page

'Language Reference'

User Functions

Database Functions

Data Manipulation Functions

Table Functions

Error Handling Functions

SQL Syntax
  • SELECT Syntax
  • INSERT Syntax
  • DELETE syntax
  • UPDATE Syntax
  • CREATE DATABASE Syntax
  • DROP DATABASE Syntax
  • SHOW DATABASES Syntax
  • USE Syntax
  • LOCK Syntax
  • UNLOCK Syntax
  • IS LOCKED Syntax
  • CREATE TABLE Syntax
  • DROP TABLE Syntax
  • SHOW TABLES Syntax
  • DESCRIBE Syntax
  • SHOW USERS Syntax
  • GRANT PERMISSIONS Syntax
  • Column Properties
  • Column Types
  • LIMIT Syntax
  • ORDERBY Syntax
  • WHERE Syntax

  • [ txtSQL Documentation powered by txtSQL | 6 SQL Queries ]