[Catalyst] SQL::Abstract and MATCH AGAINST

Hideo Kimura hide at hide-k.net
Thu Aug 17 08:52:31 CEST 2006


Hi,

I posted following suggestion to DBIC ML before.

my $aginst = 'foo';
my $rs = $schema->resultset('Articles')->search(
    {},
    {order_by => 'id desc', page => 1, limit => 10}
)->search_literal('MATCH (title, body) AGAINST( ? )', $aginst);

I dunno this is the best practice, but it works fine 
in my environment.

hide.

> 
> Any tricks to get SQL::Abstract to setup MySQL's fulltext search:
> 
>     MATCH (foo,bar) AGAINST ('+word -notword' IN BOOLEAN MODE)
> 
> with proper bind parameters?
> 
> 
> -- 
> Bill Moseley
> moseley at hank.org
> 
> 
> _______________________________________________
> List: Catalyst at lists.rawmode.org
> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
> Dev site: http://dev.catalyst.perl.org/





More information about the Catalyst mailing list