例子: case 说明 1.长期 2.有效期内 3.预上线 4.下线
SELECT ad.*, ( CASE WHEN ad.status="online" AND ad.begin_at=0 AND ad.end_at=0 THEN "1" WHEN ad.status="online" AND ad.begin_at<UNIX_TIMESTAMP()*1000 AND ad.end_at>UNIX_TIMESTAMP()*1000 THEN "1" WHEN ad.status="online" AND ad.begin_at>UNIX_TIMESTAMP()*1000 AND ad.end_at>UNIX_TIMESTAMP()*1000 THEN "1" WHEN ad.status="offline" THEN "2" ELSE "2" END ) statusTime FROM `advertisement`
例子:按照case条件查询
连表case 作为条件查询 case 说明 1.长期 2.有效期内 3.预上线 4.下线
|
SQL CASE 多条件用法
最新推荐文章于 2024-05-15 07:12:09 发布