Unknown column in where clause, but columns is specified in select

Asked Jun 25 '18 at 10:14

Active Jun 25 '18 at 10:24

Viewed 32 times

I am using the following query

SELECT COALESCE(curr_bid, start_bid) AS `bid`, `lot`.*, (SELECT COUNT(id) from bid where lot_id=lot.id) as bids_count FROM `lot` LEFT JOIN (SELECT `lot_step`.`id`, `lot_step`.`lot_id`, max(amount) as curr_bid FROM `lot_step` GROUP BY `lot_step`.`lot_id`) `ls` ON lot.id = ls.lot_id  WHERE ((`bid` >= '100') AND (`bid` <= '100000000'))

But I always get Unknown column 'bid' in 'where clause'. Not sure how can this happen, because I specified the column after SELECT

asked Jun 25 '18 at 10:14

Daniel G

1

You can't use an alias in a `where` clause – juergen d Jun 25 '18 at 10:15
@juergen d So how should i refer to the custom column? – Daniel G Jun 25 '18 at 10:17
3

Just retype it: `COALESCE(curr_bid, start_bid)` – juergen d Jun 25 '18 at 10:19
@juergend Your are right, now it works as it supposed to. Thanks for the help! – Daniel G Jun 25 '18 at 11:14

Unknown column in where clause, but columns is specified in select

0 Answers0