You almost answered your own question. In mysql you use the concat() command: select concat(number,',',text) from Table
On Thursday, September 26, 2002, at 03:17 PM, MySQL wrote: > Hi all, > > I'm a DBA in the Oracle World. > > I want to make a sql query in mysql, with a concat (||) known i Oracle > world. > > Like this. > > select numer ||','|| text from Table: > > Where the output will be eg. > > 1,HI > 2,Frank > > And so on.... > > Hope one of you can see my problem. I've tried the same on mysql, but it > mess all up. > > Regards > Frank > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 --------------------------------------------------------------------- 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