PHP mysql matching multiple row results

Question

Is there a faster way to get database results from rows that match a series of numbers?

For example, I have this...

$result = mysql_query("SELECT * FROM scores WHERE p_cat=10 OR p_cat=11 OR p_cat=12 OR p_cat=13 OR p_cat=14 OR p_cat=15 OR p_cat=16 OR p_cat=17 OR p_cat=18 OR p_cat=19 ORDER BY p_time ASC LIMIT 50")

so basically I'd like it to match row that match any number 10 through 19. But all of these ORs seem so redundant and daunting... especially when I have to do this for ranges of tens up to 200.

Barmar · Accepted Answer · 2013-11-10 04:03:41Z

3

Use BETWEEN:

WHERE p_cat BETWEEN 10 AND 19

If it's not a consecutive sequence, use IN:

WHERE p_cat IN (10, 12, 13, 15, 19)

answered Nov 10, 2013 at 4:03

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

2 Comments

gloomy.penguin Over a year ago

is that actually any faster? Or just more concise?

Barmar Over a year ago

I think it's likely to be faster, especially if there's an index on the column.

alok.kumar · Accepted Answer · 2013-11-10 05:06:29Z

0

use this code to fetch the desired result WHERE p_cat BETWEEN 10 AND 1

           $result = mysql_query("SELECT * FROM scores
               WHERE p_cat>=10 AND p_cat<=19   
              ORDER BY p_time ASC LIMIT 50")

edited Nov 10, 2013 at 5:06

answered Nov 10, 2013 at 4:18

alok.kumar

3803 silver badges11 bronze badges

Collectives™ on Stack Overflow

PHP mysql matching multiple row results

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related