Class::DBI::mysql::FullTextSearch - Full Text Indexing for Class::DBI::mysql

  package Film;
  use Class::DBI::mysql::FullTextSearch;

  __PACKAGE__->full_text_search('mysearch' => [qw/title director/]);




  package main;

  use Film;

  my @films = Film->mysearch('Godfather');
  my @films = Film->mysearch('Godfather', { sort => 'title' });
  my @films = Film->mysearch('Godfather', { nsort => 'year' });

This provides a convenient abstraction to DBIx::FullTextSearch for use with Class::DBI::mysql. It sets up lots of default values for you, handles all the updating of the index when you create, delete or edit values, and provides a simple way for you to create your search method.

  Class->full_text_search('search_method_name' => [qw/columns to index/]);

This creates your search method with the required name.

When calling the search method, if you wish to order the resulting values you can supply a field by which we either 'sort' or 'n(umeric)sort' the results.

For details on the syntax of the other search arguments etc, see DBIx::FullTextSearch.

Later versions will provide ways for you to override any of the defaults, if anyone actually requests it!

Class::DBI::mysql. Class::DBI. DBIx::FullTextSearch.

Tony Bowden and Marty Pauley

Please direct all correspondence regarding this module to: bug-Class-DBI-mysql-FullTextSearch@rt.cpan.org

Copyright (C) 2001-05 Kasei. All rights reserved.

This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.