Mysql Where and between query to database

Question

SELECT name, address FROM global WHERE (type=3) AND WHERE (id BETWEEN 3 and 7); syntax issue. but the idea is to only get row between 3 and 7 from the type 3 column.

I remove one of the () so WHERE(type=3) AND WHERE id BETWEEN 3 and 7. same error

Use the handy github link for Mysql related syntax issues: gist.github.com/hofmannsven/9164408 — ForeverLearner
– ForeverLearner, Commented Nov 5, 2017 at 6:18

ForeverLearner · Accepted Answer · 2017-11-05 06:11:43Z

1

You should use a between operator as below:

SELECT name, address FROM global WHERE type=3 
AND id BETWEEN 3 and 7;

answered Nov 5, 2017 at 6:11

ForeverLearner

2,1732 gold badges35 silver badges53 bronze badges

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

2 Comments

StuartLC Over a year ago

i.e. remove the second WHERE. The parenthesis are entirely optional.

JaP Over a year ago

Thanks, second where was not necessary. Now i got it

Collectives™ on Stack Overflow

Mysql Where and between query to database

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related