How to get this weekend events from a datetime field

[usman]

hi,

I have an events table and have a datetime field save which is event start date. I need to find all events from that start date which are in this weekend. What should be the query for this?

Also can you please let me know what will be the query for find events which are in next weekend.

Thanks,

[rocknbil]

There are a number of ways. The simplest way, note the comments by "Jeffrey Friedl" on the date and time functions docs [dev.mysql.com].

[usman]

What will be the sql query for it?