> 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
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 Vendors
-> order by vend_name
-> ;
+
