On Wednesday 14 May 2008 18:52:20 Afan Pasalic wrote: > actually, this will not work for me (or I got it wrong :D) because I > need to have street, state and zip in one line and with separator > defined on the beginning it will put everything in separate lines.
Use a 'space' as sparator instead of '\n' > > :D > > ewen fortune wrote: > > Hi Afan, > > You can use concat_ws > > > > http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_con > >cat-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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]