MYSQL select multiple rows from same column and table

Question

This question may seem a bit basic but can't seem to Google it up. Maybe it's too basic, no one bothered to make a article or forum post about it.

Anyway, I have a table called locations. I wish to call the row with the value 1, 2 and 3 from the same column. I have been using this method so far:

SELECT * FROM locations WHERE location_id='1' OR location_id='2' OR location_id='3'

However, is there a much simpler way without typing it out all over again. It is the same column afterall.

Community · Accepted Answer · 2017-11-01 17:45:13Z

8

SELECT * FROM (table name) where (column name) in [first row,second row]

when [] brackets used then put () brackets when () brackets used then don't put brackets

CommunityBot

11 silver badge

answered Jul 30, 2014 at 7:20

sumit

15.5k14 gold badges75 silver badges113 bronze badges

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

1 Comment

Thank you :) Marked ya as answer.