From: Afan Pasalic (afanafan.net)
Date: Wed May 14 2008 - 11:09:50 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Thanks Ewen,
that's what I was looking for!

:D

-afan

ewen fortune wrote:
> Hi Afan,
> You can use concat_ws
>
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat-ws
> ---
> CONCAT() returns NULL if any argument is NULL.
> CONCAT_WS() does not skip empty strings. However, it does skip any
> NULL values after the separator argument
> ---
>
> Ewen
>
> On Wed, May 14, 2008 at 5:53 PM, Afan Pasalic <afanafan.net> wrote:
>> hi,
>>
>> I have query
>> SELECT CONCAT(r.first_name, ' ', r.last_name, '\n', r.organization, '\n',
>> r.title, '\n', a.address1, '\n', a.city, ', ', a.state, ' ', a.zip, '\n',
>> r.email)
>> FROM registrants r, addresses a
>> WHERE r.reg_id=121
>>
>> if any of columns has value (e.g. title) NULL, I'll get as result 0
>> records.
>> If query doesn't have concat() - it works fine.
>>
>> Why is that?
>>
>> -afan
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=ewen.fortunegmail.com
>>
>>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]