NAME
SQL::Abstract::FromQuery::Contains - SQL::Abstract::FromQuery extension for a 'contains' rule
SYNOPSIS
my $parser = SQL::Abstract::FromQuery->new(
-components => [qw/Contains/],
-fields => {
contains => [qw/fulltext1 fulltext2/],
}
);
DESCRIPTION
This component adds rules contains
and contains_any
to the root grammar. The purpose is to generate fulltext queries to the database on some specific fields. Fields associated to such rules will generate structures of shape
{-contains => $list_of_words }
# or
{-contains_any => $list_of_words }
This is meant to work in collaboration with "SPECIAL OPERATORS" in SQL::Abstract. So the job of the present module is only to mark the query on this field as a fulltext query; then you should define a special operator named -contains
within your SQL::Abstract instance, so that this can be translated to appropriate SQL for your database.
AUTHOR
Laurent Dami, <laurent.dami AT justice.ge.ch>