w3father
w3father

Reputation: 569

How to select rows from today date?

I have a events table.

I want to select upcoming events.

my table:

tb_events has following columns

id,event_date,title,location

Upvotes: 0

Views: 738

Answers (2)

Friek
Friek

Reputation: 1541

This should do it:

SELECT * FROM tb_events WHERE event_date >= CURDATE()

Upvotes: 4

jaredonline
jaredonline

Reputation: 2902

It's in the MySQL docs.

Upvotes: 0

Related Questions