Terrence Brannon > DBIx-Cookbook-0.09 > DBIx::Cookbook::Recipe::Searching

Download:
DBIx-Cookbook-0.09.tar.gz

Annotate this POD

CPAN RT

Open  0
View/Report Bugs
Source  

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

Correlated

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

syntax highlighting: