SELECT
t1.order_no,
t1.create_time,
t2.dealer_name,
format( t1.total_price / 100, 2 ) AS total_price
FROM
`v_order` `t1`
LEFT JOIN `v_dealer` `t2` ON `t1`.`did` = `t2`.`id`
WHERE
( `t1`.`order_no` LIKE '%JAC江淮分公司%' OR `t2`.`dealer_name` LIKE '%JAC江淮分公司%' )
在TP5中实现方式:
Db::name('order')->alias('t1')->leftJoin('dealer t2', 't1.did = t2.id')
->field('t1.order_no,t1.create_time,t2.dealer_name,format(t1.total_price/100,2) as total_price')->fetchSql()
->where($where)->order($order)->select();
mysql计算字段的常用方法之一有对检索的数据进行算术计算。
mysql的算术操作符有:+,-,,/
例如一个物品表格:
price 单价