Hi,

I've read chapter 12.5 of the MySQL manual but I can't find (or perhaps overread) the answer to the following question.

When you want to select all the rows containing the current date you can do the following: SELECT * from blabla where date = curdate()

What I want is that you select all the rows containing the date from tomorrow. a logical solution would be: SELECT * from blabla where date = curdate()+1

The problem arises when you perform the query at the last day of the month. If I use that query on (for example) 31 January then he will filter all the rows containing date = 32 january.

Is there a beter solution to my problem?

DateAdd() may be more appropriate
HTH