mysql where >= = != <>

・レコードを選んで抽出
select name, created from tossy;

+--------+---------------------+
| name | created |
+--------+---------------------+
| toko | 2016-01-05 19:00:00 |
| to | 2016-01-01 15:00:00 |
| hanako | 2016-01-02 16:00:00 |
| hana | 2012-01-03 10:00:00 |
| tok | 2016-01-04 19:00:00 |
| han | 2012-01-09 10:00:00 |
+--------+---------------------+

------

・条件付きで抽出 where

select * from tossy where score >= 5.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 |
+----+------+----------------+--------+-------+---------------------+

select * from tossy where score = 8.8;
+----+------+----------------+------+-------+---------------------+
| id | name | email | team | score | created |
+----+------+----------------+------+-------+---------------------+
| 1 | toko | toko@gmail.com | red | 8.8 | 2016-01-05 19:00:00 |
+----+------+----------------+------+-------+---------------------+

select * from tossy where score != 8.8;
+----+--------+------------------+--------+-------+---------------------+
| id | name | email | team | score | created |
+----+--------+------------------+--------+-------+---------------------+
| 2 | to | to@gmail.com | blue | 9.9 | 2016-01-01 15:00:00 |
| 3 | hanako | hanako@gmail.com | blue | 3.3 | 2016-01-02 16: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 |
+----+--------+------------------+--------+-------+---------------------+

select * from tossy where score <> 8.8;
+----+--------+------------------+--------+-------+---------------------+
| id | name | email | team | score | created |
+----+--------+------------------+--------+-------+---------------------+
| 2 | to | to@gmail.com | blue | 9.9 | 2016-01-01 15:00:00 |
| 3 | hanako | hanako@gmail.com | blue | 3.3 | 2016-01-02 16: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 |
+----+--------+------------------+--------+-------+---------------------+