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'
> 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 <afan@stripped> 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=1