对于您在三个不同领域的糟糕状况,我能做的最好的事情:
select *, concat(beginyear, '-',beginmonth,'-',beingday) as full_date
FROM TABLE
WHERE CONCAT(beginyear, '-',beginmonth,'-',beingday) >= '2009-08-13'
MySQL查询返回等于或大于特定日期的行,其中日期以年,月和日列分隔
对于您在三个不同领域的糟糕状况,我能做的最好的事情:
select *, concat(beginyear, '-',beginmonth,'-',beingday) as full_date
FROM TABLE
WHERE CONCAT(beginyear, '-',beginmonth,'-',beingday) >= '2009-08-13'