As mentioned at http://dev.mysql.com/doc/refman/5.1/en/account-names.html it is possible
to mention host names as wild character containing strings using characters like '%' and
But if you check the source code, which loads the privileges from the grant tables into
the acl_users, acl_dbs.. etc arrays, the sorting function (get_sort) which is called to
sort the entries in these tables, uses the wild characters '*' and '?'.
For reference, the acl_load() function is in sql_acl.cc and is called at load time which
then calls get_sort in the same file to compute a sorting value used to quicksort the
entries in user, host and db tables.
|• Wild Characters in MySQL: Ambiguity between source code and manual||Salil Arun Bhagurkar||10 Oct|