Efficient MySQL Query Method to avoid multiple OR statement -


i quite new queries , know if there easier solution query working on.

for instance want data x 5,7,9,11,13,15 , 17.

i have query below;

select * abc x = 5 or x = 7 or x = 9 or x = 11 or x = 13 or x = 15 or x = 17; 

is okay use query or there other simpler , efficient solution?

edit

does affect perfomance when use x=[5,7,8,11,13,15,17] vs x=[5,11,7,15,8,17,13]

x id of category instance.

this shorter performs equally

select * abc x in (5,7,9,11,13,15,17) 

but remember if 1 entry in in clause null returns false.


Comments

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -