> >If there is a function to sum values, why there isn't one to sum strings
> >i.e. concat strings. Or how should i use it?
>
> You use concat to put two strings together.
I know, i have read the manual. /concat('string1','string2')/, but it
doesn't works with group by.
>>>
I would like to get this:
1 user1 '50 - twenty-three - the reason of life'
2 user2 'twenty-three - 303 rulz'
3 user3 ''
I tried:
SQL>SELECT Table1.name, ???????(Table3.txt) FROM Table1 left join Table2 on
Table1.uid=Table2.uid left join Table3 on Table2.c=Table3.c group by
Table1.name;
1 user1 '50'
2 user2 'twenty-three'
3 user3 NULL
What function should i use?
Z
---------------------------------------------------------------------
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
