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 |
+----+------+----------------+--------+-------+---------------------+