sql,query IMHO, I'd look at creating a view that postfix looks at instead of the table. This way you could concat the data for the view but keep it separate in the table. rename the table users_table or something and create a view called users.
Other than that, the concat statement I and others posted should point you in the right direction. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Patrick J Okui [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:16 AM To: Cal Evans Cc: [EMAIL PROTECTED] Subject: RE: UPDATE command.. On Tue, 16 Jul 2002, Cal Evans wrote: > well, #1, I would revision my data model. since user and domain are 2 > distinct pieces of information, I would suggest that you consider pulling > them apart and placing them in separate fields. <snip> The only problem is that this is the required structure of this table because I use it for authentication with postfix (among other things)... Thanks all the same... Patrick J Okui Systems Administrator One2net Limited --------------------------------------------------------------------- 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