mysql ・範囲に合致するもの between ・a か b のどちらか in('red','yellow');

・範囲に合致するもの between

select * from tossy where score between 5.0 and 10.0;

+----+------+----------------+--------+-------+---------------------+
| id | name | email | team | score | created |
+----+------+----------------+--------+-------+---------------------+
| 1 | toko | toko@gmail.com | red | 8.8 | 2016-01-05 19:00:00 |
| 2 | to | to@gmail.com | blue | 9.9 | 2016-01-01 15:00:00 |
| 6 | han | ha@gmail.jp | yellow | 9.2 | 2012-01-09 10:00:00 |
+----+------+----------------+--------+-------+---------------------+

-------
・a　か　b のどちらか in('red','yellow');

select * from tossy where team in ('red', 'yellow');

+----+------+----------------+--------+-------+---------------------+
| id | name | email | team | score | created |
+----+------+----------------+--------+-------+---------------------+
| 1 | toko | toko@gmail.com | red | 8.8 | 2016-01-05 19:00:00 |
| 4 | hana | ha@gmail.com | yellow | 2.2 | 2012-01-03 10:00:00 |
| 5 | tok | toko@gmail.jp | red | 1.8 | 2016-01-04 19:00:00 |
| 6 | han | ha@gmail.jp | yellow | 9.2 | 2012-01-09 10:00:00 |
+----+------+----------------+--------+-------+---------------------+