Mysql Time query

[mcdrr]

Hi I was wondering if someone would be kind enough to help me out with the following questions.

I am trying to do a query in mysql that will query a date table for a date entered up to the current date.

For example if a user enters 2006-02-02 I would like to query from 2006-02-02 to todays date.

How would the mysql query look like

select ip_src, ip_dst, sport, dport, timestamp, sig_name from acid_event where timestamp between '2006-01-22%' and ??

how would I tell the following script to search for upto today. Or if there is a better way to do it please advice.

thanks for the help and advice.

[wickning1]

Assuming timestamp is stored in one of the date formats, this should work:

[code]select ip_src, ip_dst, sport, dport, timestamp, sig_name from acid_event where timestamp between '2006-01-22' and CURDATE()[/code]