First Table Name: product_price_range
Field                          Type             
-----------------------------  
price_category_id              int(11)    
title                          varchar(155)  
min_price                      float          
max_price                      float       


Data: product_price_range
price_category_id  title        min_price  max_price 
-----------------  -----------  ---------  --------- 
                1  1-49                 1         49 
                2  50-99               50         99 
                3  100-199            100        199 
                4  200-299            200        299 
                5  300-erboven        300          0 

Second Table: product
Field               Type             
-----------------------------  
product_id           int(11)    
title                varchar(155)  
price                float          


Data: product
product_id  title            price  
---------- -----------  ---------
           1  product1       49 
           2  product2       99 
           3  product3       149 
           4  product4       249 
           5  product5       300

SELECT DISTINCT ppr.title
  FROM product_price_range AS ppr
INNER
  JOIN product AS p
    ON p.price BETWEEN ppr.min 
                   AND CASE WHEN ppr.max = 0 
                            THEN 9999999999
                            ELSE ppr.max END