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



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql