At 20:55 -0700 5/10/02, Frederick Shaul wrote: >I understand what test% might mean, but don't know what test\_% means.
It's a SQL pattern string that matches a literal "test" followed by a literal "_" followed by anything. "_" in SQL patterns normally matches any single character. "\_" escapes it to represent a literal "_". "%" is a SQL pattern character that matches any sequence of characters, including the empty string. > >Following is from a fresh MySQL install ... > >mysql> use mysql; >Reading table information for completion of table and column names >You can turn off this feature to get a quicker startup with -A > >Database changed >mysql> select * from db; >+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ >| Host | Db | User | Select_priv | Insert_priv | Update_priv | >Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv >| Index_priv | Alter_priv | >+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ >| % | test | | Y | Y | Y | >Y | Y | Y | N | Y >| Y | Y | >| % | test\_% | | Y | Y | Y | >Y | Y | Y | N | Y >| Y | Y | >+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ >2 rows in set (0.00 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
