Hi, Well, why not trying... concat() :)
SELECT concat(numer,',',text) FROM Table; http://www.mysql.com/doc/en/String_functions.html Regards, Jocelyn Fournier ----- Original Message ----- From: "MySQL" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 8:46 PM Subject: Mysql vs. Oracle and concat "||" > 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 <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- 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