I am trying to pull specific data from MYSQL table which contains a date field. The date field is not limited to just a date, it has data like (05/03/2014 8am-noon). I have created a query using REGEXP searching where date field contains today's date. It returns it just fine, however I want it to also return dates that are greater than today. How can I do that? This is what I have now, $date is a variable for today's date:
"SELECT *
FROM REGISTERED2
WHERE DATEONE REGEXP '$date or
DATETWO REGEXP '$date' or
DATETHREE REGEXP '$date' or
DATEFOUR REGEXP '$date'";
Now I would like it to search for WHERE DATEONE REGEXP >= '$date'
and so on. Is that posssible? If so, please let me know how. Thanks.