The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

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

DBIx::Cookbook::Recipe::Searching::predefined_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

Correlated

DBIx::Cookbook::Recipe::Searching::subquery_correlated