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

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

angular - password and confirm password field validation angular2 reactive forms -

php - Permission denied. Laravel linux server -