PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE orders ( id int, status enum('new','complete') ); INSERT INTO orders (id, status) VALUES (1, 'complete'), (2, 'complete'), (3, 'new'), (4, 'new'), (5, 'new'), (6, 'complete'), (7, 'new'), (8, 'new');
Copy Clear
Copy Format Clear
<?php var_export( $db::table('orders') ->selectRaw("COUNT(1) count") ->selectRaw("SUM(status = 'new') new") ->selectRaw("SUM(status = 'complete') complete") ->first() );
Show:  
Copy Clear