regex - Match the exact digit using regular expression in mysql -

i querying database table in mysql data store in below format.

example:

+------------+------------+------------+ | adv_images | start_date | end_date   |   +------------+------------+------------+ | 21.jpg     | 2013-05-22 | 2013-05-28 |          | 2.jpg      | 2013-05-22 | 2013-05-28 |         | 2a.jpg     | 2013-05-22 | 2013-05-28 |    | 2b.jpg     | 2013-05-22 | 2013-05-28 |   | 2c.jpg     | 2013-05-22 | 2013-05-28 | +------------+------------+------------+ 

there more data present in similar format 3.jpg, 3a.jpg, 3b.jpg, 41.jpg etc.

i using query query database :-

select adv_images adv_images regexp binary '^(2+[a-z]?)';

my requirement here pull adv_images starts 2 only(i.e 2.jpg, 2a.jpg etc). pulling 21.jpg, 22.jpg, 22a.jpg etc.

how can fix it.

try this

^([2+][a-z]?)\.jpg 

so query becomes

select adv_images adv_images regexp binary '^([2+][a-z]?)\.jpg';