[CDBI] Re: Search by "or".
Edward J. Sabol
sabol at alderaan.gsfc.nasa.gov
Tue Nov 28 15:13:08 GMT 2006
> For a given column Is it possible to search for more than one value?
> for instance how would I search for an employee with the first name
> of either "William" or "Bill"?
> # Search for "William".
> @employees = Comp::Employee->search( first_name => 'William' );
> is "retrieve_from_sql" the only way to do this?
Well, you could combine the results fo two searches:
@employees = Comp::Employee->search( first_name => 'William' );
push @employees, Comp::Employee->search( first_name => 'Bill' );
In my experience, that could actually be faster with some databases!
Or you could use CDBI::AbstractSearch:
Hope this helps,
More information about the ClassDBI