Database additions and deletions to the comparison of statements

Query condition action Symbol comparison

Action symbol \ Database	Description	Mysql	Sqlite	Oracle	PostgreSql	MsSql	Firebird
Equals	Name equals Michael.	' Name ' = ' Michael '
Not equal to	Name does not equal Michael	' Name ' <> ' Michael ' ' name '! = "Michael"
Less than	Age less than 10	' Age ' < 10
Less than or equal	Age is less than or equal to 10	' Age ' <= 10
Greater than	Age greater than 10	' Age ' > 10
Greater than or equal	Age greater than or equal to 10	' Age ' >= 10
String contains	Name contains Michael	' Name ' like '%michael% '
String does not contain	Name does not contain Michael	' Name ' isn't like '%michael% '
String starts with XX	Name begins with Michael	' Name ' like ' michael% '
String ending with XX	Name ends with Michael	' Name ' like '%michael '
equals null	Name equals NULL	' Name ' is NULL
Not equal to NULL	Name is not equal to NULL	' Name ' is not NULL
Between XX	Age is between 10 and 20	' Age ' between and 20
Not between XX	Age is not between 10 and 20	' Age ' not between and 20
In the list	Age is 10, 20, 30 one	' Age ' in (10,20,30)
Not in List	Age is not 10, 20, 30 one	' Age ' isn't in (10,20,30)

Database additions and deletions to the comparison of statements