Hi,
Have a look at docs below:
http://search.cpan.org/~ribasushi/DBIx-Class-0.08270/lib/DBIx/Class/ResultSet.pm#where
http://search.cpan.org/~ribasushi/SQL-Abstract-1.77/lib/SQL/Abstract.pm#SPECIAL_OPERATORS
On Sat, Mar 29, 2014 at 12:46 AM, RAPPAZ Francois
<francois.rap...@unifr.ch> wrote:
> Hi there
>
> I haven't look deep enough in the doc pages, sorry, but how can I translate
> this with resultset('table')->search_rs();
>
> SELECT * FROM table WHERE match(field1, field2, field3) against('+$bla' in
> boolean mode) ORDER BY field1 ?
>
> $bla being taken from a field and having the spaces substituted with + :
>
> my $bla = $b->get_text();
>
> ($bla=$bla)=~s/\s+/ \+/g;
>
> Thanks
>
> François
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
