MySQL : Getting Unknown column error

Question

I'm getting an error that I'm not being able to solve. I'm rather new at SQL, so I imagine this is quite an idiotic error, but I'd really appreciate somebody's help with this.

I'm trying to see if there are rows in a certain table that were created in the current week (From monday on). So I wrote this.

SELECT 
  *, 
  DATE_SUB(CURRENT_DATE,INTERVAL ( DAYOFWEEK(CURRENT_DATE) - 2 ) DAY) AS `week_start`,
  CASE WHEN `ganador`.`fecha` >= `week_start` THEN 0 ELSE 1 END AS `this_week`
FROM `lesaffre_ganadores` as `ganador`

I'm getting the following error:

1054 - Unknown column 'week_start' in 'field list'

I assume there is a way to define the variable week_start in order to be able to use it in the query, but I really ignore it.

Could anyone help me?

Thank you very much!

sumit · Accepted Answer · 2017-01-03 22:45:47Z

1

SELECT 
*,
CASE WHEN `ganador`.`fecha` >= `week_start` THEN 0 ELSE 1 END AS `this_week`

FROM
(
SELECT 
  *, 
  DATE_SUB(CURRENT_DATE,INTERVAL ( DAYOFWEEK(CURRENT_DATE) - 2 ) DAY) AS `week_start`
FROM `lesaffre_ganadores` 
)ganador

answered Jan 3, 2017 at 22:45

sumit

15.5k14 gold badges75 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sebi Sanchez Over a year ago

This worked really well. I get what my error was. Thanks a lot.

Collectives™ on Stack Overflow

MySQL : Getting Unknown column error

1054 - Unknown column 'week_start' in 'field list'

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1054 - Unknown column 'week_start' in 'field list'

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related