SQL - help and a little clarity

I am trying to have MySQL give information based on multiple conditions being met. I remember how to do it with one: 
select * from table where username='tigger';

But I'd like to do it with more conditions, something like this:
select * from table where username='tigger' and date='2008-07-28' and time='11:41:56';
Can someone assist me with what would be the correct syntax? I know this is a simple one, but it's escaping me at the moment.
PS. I'm using perl to connect to the MySQL database using the DBI(). I'm not sure what difference that will make, except to say that the three conditions that need to be met will be from variables passed on from perl. 

Thanks for any help.

With All Respect,
Upshaw, Lamar T 
__________
View the list's information and change your settings at http://www.freelists.org/list/programmingblind

Other related posts: