RE: Underscore functions as a wildcard ?

[EMAIL PROTECTED] > Sent: Wednesday, June 29, 2005 10:27 AM > To: John Trammell > Cc: mysql@lists.mysql.com > Subject: Re: Underscore functions as a wildcard ? > > This is not a bug. Mysql uses _ as the single-character > wildcard, and % as > the multi-character wildcar

Re: Underscore functions as a wildcard ?

This is not a bug. Mysql uses _ as the single-character wildcard, and % as the multi-character wildcard in pattern matches. This is clearly explained in the manual : Note: the '_' and '%' wildcards are allowed when specifying database names in

Re: Underscore functions as a wildcard ?

Hello. Could you give a test case? For example I've done these steps, and user u1 couldn't create tables in other databases. grant all privileges on `user\_data`.* to 'u1'@'localhost' identified by 'u1'; grant select on user2data.* to [EMAIL PROTECTED]; Then I've logged in as u1. u

RE: Underscore functions as a wildcard ?

I recall seeing this "feature" discussed on Bugtraq a few weeks ago. IIRC there are updated MySQL versions that fix this bug. What version of MySQL are you running? > -Original Message- > From: Jeroen Bosch [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 29, 2005 6:59 AM > To: mysql@l