MySQL Regexp to match image links

Question

I tried this expression

 SELECT * FROM `table` WHERE COL REGEXP "^([%\w-]+\.(?:jpe?g¦JPE?G¦gif¦GIF¦png¦PNG))$"

Please help me

how are these image links stored in the table

hjpotter92
– hjpotter92

2012-04-23 03:10:45 +00:00
Commented Apr 23, 2012 at 3:10 — hjpotter92
– hjpotter92, Commented Apr 23, 2012 at 3:10
image links is http://(.*?)\.(jpg|png|jpeg|gif|bmp)

Thoman
– Thoman

2012-04-23 04:09:28 +00:00
Commented Apr 23, 2012 at 4:09 — Thoman
– Thoman, Commented Apr 23, 2012 at 4:09

g13n · Accepted Answer · 2012-04-23 03:16:06Z

3

@Thoman I assume that the column stores image paths, in which case you could just look for column having the ".jpg", etc. extension as opposed to matching the whole path.

SELECT * FROM `table` WHERE col REGEXP '\.(jpe?g|gif|png)'

If you have the col with values like /tmp/foo.gif then it wouldn't match the \w+ (word characters expression.)

Hope this helps.

answered Apr 23, 2012 at 3:16

g13n

3,2662 gold badges27 silver badges19 bronze badges

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

1 Comment

hjpotter92 Over a year ago

It works perfectly. In case Thoman wants a sample, here is a sqlfiddle. Please ignore me using Zelda links :)

Collectives™ on Stack Overflow

MySQL Regexp to match image links

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related