How come the query
SELECT
CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif
ied,bugstatus,submitter), '"') FROM tbl_bug;
returns something like
"4","4","4"
"10","10","10"
while only
SELECT
CONCAT_WS(';',title,prio,category,program,bugdesc,created,modified,bugstatus
,submitter) FROM tbl_bug;
returns the intended result except that the values are not confined withing
'"'.
that is
Tough Bug,1,3,4,A very long description....
I do understand why the second query returns what it returns, but the first
one should not return what it returns, right?
Am I clear enough?
I'm using 2.23.33 on Windows 2000 Server.
/ Rasmus Nyström
---------------------------------------------------------------------
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
