SQL::KeywordSearch Generate SQL for simple keyword searches
Download

SQL::KeywordSearch Ranking & Summary

SQL::KeywordSearch Tags

SQL Perl module keyword searches SQL generator keyword searches

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