LikeExpression class final

A LIKE expression in SQL, with an optional ESCAPE clause.

Inheritance
Available extensions

Properties

escape → Expression<String>?
An optional custom escape character for right.
final
hashCode → int
The hash code for this object.
no setteroverride
left → Expression<String>
The string being searched.
final
precedence → Precedence
The precedence of this expression. This can be used to automatically put parentheses around expressions as needed.
no setteroverride
The text to search for.
final
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
sqlType → SqlType<bool>
Resolves the SqlType implementation describing the type of this expression.
no setterinherited

Methods

caseMatch<R extends Object>({required Map<Expression<bool>, Expression<R>> when, Expression<R>? orElse}) → Expression<R>
A CASE WHEN construct using the current expression as a base.
inherited
cast<T2 extends Object>([SqlType<T2>? type]) → Expression<T2>
Generates a CAST(expression AS TYPE) expression.
inherited
compileWith(StatementCompiler compiler) → void
Compiles this component with the given StatementCompiler by invoking the relevant add method on it.
override
dartCast<T2 extends Object>({SqlType<T2>? customType}) → Expression<T2>
Casts this expression to an expression of D.
inherited
equals(bool compare) → Expression<bool>
Whether this column is equal to the given value, which must have a fitting type. The compare value will be written as a variable using prepared statements, so there is no risk of an SQL-injection.
inherited
equalsExp(Expression<bool> compare) → Expression<bool>
Whether this expression is equal to the given expression.
inherited
equalsNullable(bool? compare) → Expression<bool>
Compares the value of this column to compare or null.
inherited
iif(Expression<bool> predicate, Expression<bool> ifFalse) → Expression<bool>
Evaluates to this if predicate is true, otherwise evaluates to ifFalse.
inherited
isExp(Expression<bool> other) → Expression<bool>
Generates an IS expression in SQL, comparing this expression with the other expression.
inherited
isIn(Iterable<bool> values) → Expression<bool>
An expression that is true if this resolves to any of the values in values.
inherited
isInExp(List<Expression<bool>> expressions) → Expression<bool>
An expression that evaluates to true if this expression resolves to a value that one of the expressions resolve to as well.
inherited
isInQuery(BaseSelectStatement<BaseSelectStatement, dynamic> select) → Expression<bool>
An expression checking whether this is included in any row of the provided select statement.
inherited
isNotExp(Expression<bool> other) → Expression<bool>
Generates an IS NOT expression in SQL, comparing this expression with the other expression.
inherited
isNotIn(Iterable<bool> values) → Expression<bool>
An expression that is true if this does not resolve to any of the values in values.
inherited
isNotInExp(List<Expression<bool>> expressions) → Expression<bool>
An expression that evaluates to true if this expression does not resolve to any value that the expressions resolve to.
inherited
isNotInQuery(BaseSelectStatement<BaseSelectStatement, dynamic> select) → Expression<bool>
An expression checking whether this is not included in any row of the provided select statement.
inherited
isNotNull() → Expression<bool>
Expression that is true if the inner expression resolves to a non-null value.
inherited
isNotValue(bool value) → Expression<bool>
Generates an IS NOT expression in SQL, comparing this expression with the Dart value.
inherited
isNull() → Expression<bool>
Expression that is true if the inner expression resolves to a null value.
inherited
isValue(bool value) → Expression<bool>
Generates an IS expression in SQL, comparing this expression with the Dart value.
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
not() → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Negates this boolean expression. The returned expression is true if this is false, and vice versa.
nullIf(Expression<bool> matcher) → Expression<bool>
Returns null if matcher is equal to this expression, this otherwise.
inherited
toString() → String
A string representation of this object.
inherited
variable(bool? value) → Variable<bool>
Creates a variable that is guaranteed to have the same SqlType as this.
inherited

Operators

operator &(Expression<bool> other) → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Returns an expression that is true iff both this and other are true.
operator ==(Object other) → bool
The equality operator.
override
operator |(Expression<bool> other) → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Returns an expression that is true if this or other are true.