SQL::KeywordSearchGenerate SQL for simple keyword searches | |
Download |
SQL::KeywordSearch Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Mark Stosberg
- Publisher web site:
- http://search.cpan.org/~mgraham/
SQL::KeywordSearch Tags
SQL::KeywordSearch Description
Generate SQL for simple keyword searches The solution provided by SQL::KeywordSearch is simple, suitable for relatively small numbers of rows and columns. It is also simple-minded in that it can't sort the results based on their relevance.For large data sets and more features, a full-text indexing and searching solution is recommended to be used instead. Tsearch2 for PostgreSQL, http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ is one such solution.SYNOPSIS use SQL::KeywordSearch; my ($search_sql,@bind) = sql_keyword_search( keywords => 'cat,brown,whiskers', columns => ); my $sql = "SELECT title from articles WHERE user_id = 5 AND ".$search_sql; Requirements: · Perl
SQL::KeywordSearch Related Software