MYSQL query syntax correction

Question

Need some help on MYSQL query syntax, I am able to get last 60 records but wanted to exclude this week's record. I am trying following but can't able to figure out correct syntax.

select TIMESTAMP,ID,MAX,MIN from 
 (select TIMESTAMP,ID,MAX,MIN from db 
  where ID = 'A0101'  
  WHERE YEARweek(TIMESTAMP) =! YEARweek(current_DATE) 
  group by TIMESTAMP desc limit 60) t 
order by TIMESTAMP asc

Is this your query? Two where clause in one select? No error? — Ocaso Protal
– Ocaso Protal, Commented Aug 11, 2011 at 12:17

Randy · Accepted Answer · 2011-08-11 12:19:56Z

2

select TIMESTAMP,ID,MAX,MIN from db 
  where ID = 'A0101'  
  AND YEARweek(TIMESTAMP) != YEARweek(current_DATE) 
  group by TIMESTAMP desc limit 60
order by TIMESTAMP asc

Comments

glglgl · Accepted Answer · 2011-08-11 12:18:42Z

0

Probably it is just the =! which negates YEARweek() and compares to the other YEARweek().

You should try != instead.

Currently, I cannot tell more, as you don't show what is wrong or what happens or doesn't happen with your query.

answered Aug 11, 2011 at 12:18

glglgl

91.5k13 gold badges157 silver badges230 bronze badges

1 Comment

glglgl Over a year ago

right. Needs two, three more glances on it - would have been easier to spot if original would be accompagnied by an error message. ("It doesn't work" is none.)

Collectives™ on Stack Overflow

MYSQL query syntax correction

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related