Documentation Index Fetch the complete documentation index at: https://docs.omniql.com/llms.txt
Use this file to discover all available pages before exploring further.
Filter data using WHERE clauses with various operators.
Comparison Operators : GET User WHERE age = 25 : GET User WHERE age != 25 : GET User WHERE age > 21 : GET User WHERE age >= 21 : GET User WHERE age < 65 : GET User WHERE age <= 65
Operator Meaning =Equal !=Not equal >Greater than >=Greater than or equal <Less than <=Less than or equal
Logical Operators AND : GET User WHERE age > 21 AND status = "active"
Database Output PostgreSQL SELECT * FROM users WHERE age > 21 AND status = 'active'MongoDB db.users.find({ age: { $gt: 21 }, status: 'active' })
: GET User WHERE role = "admin" OR role = "moderator"
Database Output PostgreSQL SELECT * FROM users WHERE role = 'admin' OR role = 'moderator'MongoDB db.users.find({ $or: [{ role: 'admin' }, { role: 'moderator' }] })
Combined with Parentheses : GET User WHERE (age > 21 AND status = "active" ) OR role = "admin"
IN Operator Match against a list of values.
: GET User WHERE role IN ( "admin" , "moderator" , "editor" )
Database Output PostgreSQL SELECT * FROM users WHERE role IN ('admin', 'moderator', 'editor')MongoDB db.users.find({ role: { $in: ['admin', 'moderator', 'editor'] } })
NOT IN : GET User WHERE status NOT IN ( "banned" , "suspended" )
BETWEEN Operator Match a range of values.
: GET User WHERE age BETWEEN 18 AND 65
Database Output PostgreSQL SELECT * FROM users WHERE age BETWEEN 18 AND 65MongoDB db.users.find({ age: { $gte: 18, $lte: 65 } })
Date Range : GET Order WHERE created_at BETWEEN "2024-01-01" AND "2024-12-31"
NOT BETWEEN : GET Product WHERE price NOT BETWEEN 10 AND 50
LIKE Operator Pattern matching for strings.
: GET User WHERE name LIKE "John%" : GET User WHERE email LIKE "%@gmail.com" : GET User WHERE name LIKE "%smith%"
Pattern Meaning John%Starts with “John” %@gmail.comEnds with “@gmail.com” %smith%Contains “smith”
Database Output PostgreSQL SELECT * FROM users WHERE name LIKE 'John%'MongoDB db.users.find({ name: { $regex: '^John' } })
NOT LIKE : GET User WHERE email NOT LIKE "%@test.com"
ILIKE (Case Insensitive) : GET User WHERE name ILIKE "john%"
Database Output PostgreSQL SELECT * FROM users WHERE name ILIKE 'john%'MySQL SELECT * FROM users WHERE LOWER(name) LIKE 'john%'
NULL Checks : GET User WHERE deleted_at IS NULL : GET User WHERE phone IS NOT NULL
Database Output PostgreSQL SELECT * FROM users WHERE deleted_at IS NULLMongoDB db.users.find({ deleted_at: null })
Complex Example : GET id, name , email FROM User WHERE status = "active" AND age BETWEEN 21 AND 45 AND role IN ( "user" , "premium" ) AND email LIKE "%@company.com" AND deleted_at IS NULL
Next Steps
Sorting ORDER BY operations
Advanced Queries CTEs, subqueries, and set operations
