select * where id = 1,2,3

Helpful Herring answered on October 14, 2020 Popularity 7/10 Helpfulness 5/10

answer select * where id = 1,2,3

Comment

SELECT * FROM Table WHERE id IN (1,2,3,4,5) AND ColB = (SELECT ColB FROM Table WHERE id IN (1,2,3,4,5) ORDER BY FIELD(id,1,2,3,4,5) LIMIT 1)

Popularity 7/10 Helpfulness 5/10 Language sql

Tags: select sql where

Link to this answer
Share Copy Link

Contributed on Oct 14 2020

Helpful Herring

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.