
上图是tp的sql写法。
SELECT * FROM `bg_coupons` WHERE `usercard` = '100002345' AND `usedate` is null OR usedate = '0000-00-00 00:00:00' AND `couponsdate` <= '2016-11-09 10:21:41' AND `couponedate` >= '2016-11-09 10:21:41' AND `couponscode` = '343' LIMIT 1
这个是解析后的原生sql语句
SELECT * FROM `bg_coupons` WHERE `usercard` = '100002345' AND (`usedate` is null OR usedate = '0000-00-00 00:00:00') AND `couponsdate` <= '2016-11-09 10:21:41' AND `couponedate` >= '2016-11-09 10:21:41' AND `couponscode` = '343' LIMIT 1
这个是我手写的原生SQL语句
问题:请问,用TP写法,如何实现最后一条原生sql语句呢?
最佳答案