running regex query with mysql

Question

I am running this regex: ^https?:\/\/www\.chkhikvadze\.com\/[a-z0-9-/]+-[0-9]\.[0-9]{7}$ and getting this error: My sql error 1139 invalid character name.

when i remove this fragment [a-z0-9-/] or only -/ it works. how can i fix it?

Try ^https?://www[.]chkhikvadze[.]com/[a-z0-9/-]+-[0-9][.][0-9]{7}$ — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Jan 31, 2017 at 12:30
escape the "-", "/" and ".": ^https?:\/\/www\.chkhikvadze\.com\/[a-z0-9\-\/]+\-[0-9]\.[0-9]{7}$ — ZiTAL
– ZiTAL, Commented Jan 31, 2017 at 12:40

fafl · Accepted Answer · 2017-01-31 12:35:25Z

1

Just put the dash in front:

^https?:\/\/www\.chkhikvadze\.com\/[-a-z0-9/]+-[0-9]\.[0-9]{7}$

The parser thinks that 9-/ is supposed to be a range like a-z, but complains that it's not valid.

answered Jan 31, 2017 at 12:35

fafl

7,5074 gold badges32 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

running regex query with mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related