mysql ・and 指定した、条件が全て揃ったもの ・or どっちかの条件が当てはまったもの

・and 指定した、条件が全て揃ったもの

select * from tossy where score >= 4.0 and team = 'yellow';

+----+------+-------------+--------+-------+---------------------+
| id | name | email | team | score | created |
+----+------+-------------+--------+-------+---------------------+
| 6 | han | ha@gmail.jp | yellow | 9.2 | 2012-01-09 10:00:00 |
+----+------+-------------+--------+-------+---------------------+

・or どっちかの条件が当てはまったもの

select * from tossy where score >= 4.0 or team = 'yellow';

+----+------+----------------+--------+-------+---------------------+
| 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 |
| 4 | hana | ha@gmail.com | yellow | 2.2 | 2012-01-03 10:00:00 |
| 6 | han | ha@gmail.jp | yellow | 9.2 | 2012-01-09 10:00:00 |
+----+------+----------------+--------+-------+---------------------+