NAME
DBIx::Cookbook::Recipe::Searching - Recipes for searching databases
RECIPES
Fetch all records from a table
DBIx::Cookbook::Recipe::Searching::fetch_all
Fetch a single record from a query which could return many
DBIx::Cookbook::Recipe::Searching::fetch_single
A query with a complex WHERE
DBIx::Cookbook::Recipe::Searching::complex_where
how to issue a query with a database function as one of the return columns
DBIx::Cookbook::Recipe::Searching::db_func
Flexibly return a distinct resultset or the count of it
DBIx::Cookbook::Recipe::Searching::distinct_count
Using GROUP BY
DBIx::Cookbook::Recipe::Searching::grouping
Paged result sets
DBIx::Cookbook::Recipe::Searching::paged
Storing a predefined search
DBIx::Cookbook::Recipe::Searching::predefined_search
specifying which columns to retrieve from a search
DBIx::Cookbook::Recipe::Searching::specific_columns
Selecting a particular column
DBIx::Cookbook::Recipe::Searching::get_column
Using SQL on the LHS of an comparison
While not usually advised, DBIx::Cookbook::Recipe::Searching::sql_lhs contains recipes for using a database function on the LHS of a comparison
Subqueries
Simple
DBIx::Cookbook::Recipe::Searching::subquery