module Sequel::SQL::StringMethods
This module includes the like
and ilike
methods
used for pattern matching that are defined on objects that can be used in
a string context in SQL (Symbol
,
LiteralString
, SQL::GenericExpression
).
Public Instance Methods
Create a EscapedLikeExpression
case insensitive pattern match
of the receiver with the patterns, interpolated escaped values for each +?+
placeholder in the pattern.
Sequel[:a].escaped_ilike('?%', 'A') # "a" ILIKE 'A%' ESCAPE '\' Sequel[:a].escaped_ilike('?%', '%A') # "a" ILIKE '\%A%' ESCAPE '\'
# File lib/sequel/extensions/escaped_like.rb, line 84 def escaped_ilike(placeholder_pattern, placeholder_values) EscapedLikeExpression.new(self, false, placeholder_pattern, placeholder_values) end
Create a EscapedLikeExpression
case sensitive pattern match of
the receiver with the patterns, interpolated escaped values for each +?+
placeholder in the pattern.
Sequel[:a].escaped_like('?%', 'A') # "a" LIKE 'A%' ESCAPE '\' Sequel[:a].escaped_like('?%', '%A') # "a" LIKE '\%A%' ESCAPE '\'
# File lib/sequel/extensions/escaped_like.rb, line 94 def escaped_like(placeholder_pattern, placeholder_values) EscapedLikeExpression.new(self, true, placeholder_pattern, placeholder_values) end
Create a BooleanExpression
case insensitive pattern match of
the receiver with the given patterns. See
StringExpression.like
.
Sequel[:a].ilike('A%') # "a" ILIKE 'A%' ESCAPE '\'
# File lib/sequel/sql.rb, line 930 def ilike(*ces) StringExpression.like(self, *(ces << {:case_insensitive=>true})) end
Create a BooleanExpression
case sensitive (if the database
supports it) pattern match of the receiver with the given patterns. See
StringExpression.like
.
Sequel[:a].like('A%') # "a" LIKE 'A%' ESCAPE '\'
# File lib/sequel/sql.rb, line 938 def like(*ces) StringExpression.like(self, *ces) end