Module: Sequel::SQL::StringMethods

Included in:
Dataset, LiteralString, GenericExpression, StringExpression, Symbol
Defined in:
lib/sequel/sql.rb

Overview

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).

Instance Method Summary (collapse)

Instance Method Details

- (Object) ilike(*ces)

Create a BooleanExpression case insensitive pattern match of the receiver with the given patterns. See StringExpression.like.

:a.ilike('A%') # "a" ILIKE 'A%'


891
892
893
# File 'lib/sequel/sql.rb', line 891

def ilike(*ces)
  StringExpression.like(self, *(ces << {:case_insensitive=>true}))
end

- (Object) like(*ces)

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%'


899
900
901
# File 'lib/sequel/sql.rb', line 899

def like(*ces)
  StringExpression.like(self, *ces)
end