"Alex E.Wintermann" <[EMAIL PROTECTED]> wrote:
>
> MySQL 4.1.0-alpha-max-nt
> phpMyAdmin 2.5.4
>
> /* BEGIN DUMP */
> CREATE TABLE `sp_tovar_vid` (
> `id` int(11) NOT NULL auto_increment,
> `id_tovar_vid` int(11) NOT NULL default '0',
> `name` varchar(100) NOT NULL default '',
> `description` varchar(255) NOT NULL default '',
> UNIQUE KEY `id` (`id`)
> ) TYPE=InnoDB CHARSET=cp1251;
>
> INSERT INTO `sp_tovar_vid` VALUES (1, 0, 'string 1', '');
> INSERT INTO `sp_tovar_vid` VALUES (2, 1, 'string 2', '');
> INSERT INTO `sp_tovar_vid` VALUES (3, 2, 'string 3', '');
> INSERT INTO `sp_tovar_vid` VALUES (4, 0, 'string 4', '');
>
> INSERT INTO `sp_tovar_vid` (`id`,`id_tovar_vid`,`name`,`description`) VALUES
> ('','0','','');
> UPDATE `sp_tovar_vid` SET `id` = '0' WHERE `id` = LAST_INSERT_ID() LIMIT 1 ;
> /* END DUMP */
>
> /* BEGIN QUERY */
> SELECT t1.`id`,
> CONCAT(if(t3.`name`='','',CONCAT(t3.`name`,' ->
> ')),if(t2.`name`='','',CONCAT(t2.`name`,' -> ')),t1.`name`) AS col1,
> t1.`description`
> FROM `sp_tovar_vid` AS t1,
> `sp_tovar_vid` AS t2,
> `sp_tovar_vid` AS t3
> WHERE t1.`id_tovar_vid`=t2.`id` AND
> t2.`id_tovar_vid`=t3.`id` AND
> col1>'string'
> ORDER BY col1;
> /* END QUERY */
>
> QUESTION: why ERROR caused: #1054 - Unknown column 'col1' in 'where clause'
You can't use column alias in the WHERE clause. Use HAVING instead:
http://www.mysql.com/doc/en/Problems_with_alias.html
>
> result wanted
> +----+----------------------------------+-------------+
> | id | col1 | description |
> +----+----------------------------------+-------------+
> | 1 | string 1 | |
> | 2 | string 1 -> string 2 | |
> | 3 | string 1 -> string 2 -> string 3 | |
> | 4 | string 4 | |
> +----+----------------------------------+-------------+
> 4 rows in set (0.00 sec)
> /**/
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
