想要執(zhí)行的SQL語句為
SELECT * FROM `aj_land` WHERE `land_no` = '0' AND ( `custom_name` LIKE '%4%' OR `custom_phone` LIKE
'%4%' ) AND `custom_id` = 0 LIMIT 1
tp5查詢寫法為
$where['land_no'] = 0;
if ($post['keyword']) {
$where['custom_name|custom_phone'] = ['like', "%" . $post['keyword'] . '%'];
}
$where['custom_id'] = 0;
$num = db('land')->where($where)->select();
