fork download
copy 
  1. select id from vote
  2. where 
  3.  case when cond01 > 50 then 1 else 0 end +
  4.  case when cond02 > 50 then 1 else 0 end +
  5.  case when cond03 > 50 then 1 else 0 end +
  6.  case when cond04 > 50 then 1 else 0 end +
  7.  case when cond05 > 50 then 1 else 0 end +
  8.  case when cond06 > 50 then 1 else 0 end +
  9.  case when cond07 > 50 then 1 else 0 end +
  10.  case when cond08 > 50 then 1 else 0 end +
  11.  case when cond09 > 50 then 1 else 0 end +
  12.  case when cond10 > 50 then 1 else 0 end
  13.  >= 9;
  14.  
  15. 98 rows in set (0.01 sec)
  16.  
  17. explain
  18. +------+-------------+-------+------+---------------+------+---------+------+------+-------------+
  19. | id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | Extra       |
  20. +------+-------------+-------+------+---------------+------+---------+------+------+-------------+
  21. |    1 | SIMPLE      | vote  | ALL  | NULL          | NULL | NULL    | NULL | 9851 | Using where |
  22. +------+-------------+-------+------+---------------+------+---------+------+------+-------------+
  23.  
Not running #stdin #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/ceErb8
language:
Text (text 6.10)
created:
5 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!