Combining Columns in MySQL for PHP
| From: | Chris Earle | Date: | Sat, 27 Jul 2002 19:37:31 +0000 |
| Subject: | Combining Columns in MySQL for PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-109996@lists.php.net to get a copy of this message | ||
I was wondering if there was any way to get MySQL to combine the specified
SELECT columns into one column.
i.e.,
SELECT COMBINE(column_1, column_2) As column FROM column_list;
Would give me the results of column_1 and column_2 simply by going through
"column".
Is there any thing that does this in MySQL, or do I have to do this in PHP?
I've been searching mysql.com, but there search engine seems to be broken
and gives me errors frequently. :(