delete all hosts using a wildcard

[Tim Dunphy]

hello list,

 I have a number of hosts that I would like to delete using a wildcard (%) symbol. 

  Here is the query I am using:
  
  mysql> delete from mysql.user where user='%.summitnjhome.com';
Query OK, 0 rows affected (0.00 sec)

 And I am attempting to delete all the hosts at the domain 'summitnjhome.com'...

 But as you can see I am unsuccessful:

 mysql> select user,host from mysql.user;
+----------+-----------------------------+
| user     | host                        |
+----------+-----------------------------+
| root     | 127.0.0.1                   |
| repl     | virtcent10.summitnjhome.com |
| admin    | virtcent11.summitnjhome.com |
| repl     | virtcent19.summitnjhome.com |
| repl     | virtcent23.summitnjhome.com |
| repl     | virtcent30.summitnjhome.com |
+----------+-----------------------------+


I know I can delete them individually and this is what I am going to do. But I would like
to use this as a learning opportunity to help me understand how the wildcard works. 

Thanks in advance..

Best regards,
Tim