MySQL UNION 用法

/**

* @desc 处理coupon防刷风控限制sql查询逻辑

* @param array $userInfo

* @param string $codeInfo

* @return array|bool

*/

function codeFangShua($userInfo,$codeInfo)

{

$startTime = strtotime(date('Y-m-d'));// 当天开始时间

$sql = "SELECT * FROM order_info WHERE add_time >= $startTime ".

"AND promotion_code = '{$codeInfo}' AND address='{$userInfo['address']}' ".

"UNION ".

"SELECT * FROM order_info WHERE add_time >= $startTime ".

"AND promotion_code = '{$codeInfo}' AND address='{$userInfo['address']}' ".

"AND consignee = '{$userInfo['consignee']}' ".

"UNION ".

"SELECT * FROM order_info WHERE add_time >= $startTime ".

"AND promotion_code = '{$codeInfo}' AND tel = '{$userInfo['tel']}' ".

"UNION ".

"SELECT * FROM order_info WHERE add_time >= $startTime ".

"AND promotion_code = '{$codeInfo}' AND email = '{$userInfo['email']}'";

$Model = M();

$orderInfo = $Model->query($sql);

return $orderInfo ;

}