MySQL : between value in string

Question

I'm trying to build a query which matches the rows following these rules :

my rows contents ids like 'MATCH_1', 'MATCH_2', 'MATCH_4'...
I want to match the rows which id is between 2 boundaries: SELECT id FROM table WHERE id LIKE "MATCH_%", % must be between 2 and 5 for example. The result must be : 'MATCH_2', 'MATCH_4', 'MATCH_5'

Is it possible to do so ?

Thanks

And I suppose that MATCH_10 is not between MATCH_1 and MATCH_2, is it? — Álvaro González
– Álvaro González, Commented Mar 5, 2013 at 9:59

Mahmut Ali ÖZKURAN · Accepted Answer · 2013-03-05 10:17:58Z

7

you mean this?

 SELECT * 
   FROM table
  WHERE row 
BETWEEN 'MATCH_2' AND 'MATCH_5';

or converted to int

  SELECT *
    FROM table
   WHERE CAST(SUBSTRING(row FROM 7) AS UNSIGNED)
 BETWEEN 2 AND 5;

answered Mar 5, 2013 at 10:00

1,1492 gold badges23 silver badges28 bronze badges

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

1 Answer 1