-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Duncan & Rob, et al --
...and then Salada, Duncan said... % % Why 2 CONCATs? Why not simply: % % mysql -Be "select CONCAT(host,'.',domain) from easyadmin.vsites where % adminuser="davidtg" Hey, cool! That's *exactly* what I needed. Works perfectly. I *promise* I looked in the reference manual; CONCAT does not appear in the TOC at all, and there is no "how do I glue these fields together" example listed in the 3.5 examples. % % Duncan Thanks again & HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+S69+Gb7uCXufRwARAlpKAJ4pFHXckSnJjPskCCttxfTl2Nc8PwCgwloU Vb1wRYgnNlMT/QpEuz4s/M0= =cUlI -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
