Module | Sequel::SQL::StringMethods |
In: |
lib/sequel/sql.rb
|
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).
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 895 895: def ilike(*ces) 896: StringExpression.like(self, *(ces << {:case_insensitive=>true})) 897: end
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 903 903: def like(*ces) 904: StringExpression.like(self, *ces) 905: end