Re: How to get each value out of set function?
| From: | Thimble Smith | Date: | Wed, 25 Oct 2000 19:55:57 +0000 |
| Subject: | Re: How to get each value out of set function? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-21916@lists.php.net to get a copy of this message | ||
On Wed, Oct 25, 2000 at 11:03:38AM -0400, Wee Chua wrote:
> For example, if the table A for user 111 (ignore the host the
> db fields) has select, insert and update privileges on the
> table_priv column of mysql.tables_priv table, how could I find
> out the insert privileges is true on the field?
Check the documentation for find_in_set().
select find_in_set('Insert', Table_priv) as has_insert
from mysql.tables_priv
Tim
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Tim Smith <tim@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team
/_/ /_/\_, /___/\___\_\___/ Boone, NC USA
<___/ www.mysql.com