> mysql> select vend_city+', '+vend_state+' '+vend_zip
> -> from Vendors
> -> order by vend_name
> -> ;
...
> 4 rows in set (0.01 sec)
>
> How do I do this in MySQL?
SELECT CONCAT(vend_city, ', ', vend_state, ' ', vend_zip) FROM Vendors ORDER
BY vend_name;
--
At 5:54 PM -0700 7/16/01, Bob Rea wrote:
>Still reading SQL in 10 Minutes, and here is the next problem, string
>concatenation in SELECT queries. The book has this query and this
>result. The other data is there in the table.
>
>mysql> select vend_city+', '+vend_state+' '+vend_zip
> -> from Ve
Good tutorial
http://www.mysql.com/articles/ddws/index.html
enjoy
Ken
- Original Message -
From: "Bob Rea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 5:54 PM
Subject: Next Newbie Question
> Still reading SQL in 10 Minutes, and here is the next problem, stri
