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
ilike(*ces)
click to toggle source
Create a BooleanExpression
case insensitive pattern match of
the receiver with the given patterns. See
StringExpression.like
.
:a.ilike('A%') # "a" ILIKE 'A%' ESCAPE '\'
# File lib/sequel/sql.rb, line 893 def ilike(*ces) StringExpression.like(self, *(ces << {:case_insensitive=>true})) end
like(*ces)
click to toggle source
Create a BooleanExpression
case sensitive (if the database
supports it) pattern match of the receiver with the given patterns. See
StringExpression.like
.
:a.like('A%') # "a" LIKE 'A%' ESCAPE '\'
# File lib/sequel/sql.rb, line 901 def like(*ces) StringExpression.like(self, *ces) end