mysql ・曖昧な検索 like % 任意の文字列 _ 文字数

select * from tossy where email like '%gmail.com';

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

select * from tossy where email like '%com';

select * from tossy where email like '%gmail.__';

+----+------+---------------+--------+-------+---------------------+
| id | name | email | team | score | created |
+----+------+---------------+--------+-------+---------------------+
| 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 |
+----+------+---------------+--------+-------+---------------------+