How to use between in MySQL ansi query?

Question

I need to query something using INNER JOIN, how can I use WHERE user_id between 2000 and 3000 inside ANSI query

e.g.

SELECT table1.name, table2.wage, table2.bonus table3.shift, table4.vacation FROM table1 INNER JOIN table2 ON table1.userid = table2.userid INNER JOIN table3 ON table2.userid = table3.userid INNER JOIN table4 ON table4.userid = table4.userid LEFT JOIN table5 ON table1.name = table5.position

also, I need to limit table2.wage between 2000 and 4000 how can I represent it

wonk0 · Accepted Answer · 2011-08-01 10:35:04Z

1

Well, a BETWEEN x AND y is nothing else then ( a >= x AND a <= y ), so

WHERE ( user_id >= 2000 AND user_id <= 3000 )

should do

answered Aug 1, 2011 at 10:35

wonk0

14.1k1 gold badge23 silver badges15 bronze badges

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

1 Comment

BUddhaxx Over a year ago

can i put where in ANSI query where exactly i put it

Collectives™ on Stack Overflow

How to use between in MySQL ansi query?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related