Making sure a url parameter is not present, using regex

Question

I need 2 regular expressions that I will use in MySQL

OK if one of the url parameters equals something (e.g page_id=5)
I came up with this: ^https?:.*[?&]page_id=5([#&].*)?$
OK if a certain parameter is not present in the url (e.g do not match [?&]page_id=)
This is the one I need help with.

This functionality is part of a bigger problem that does need to be implemented with regular expressions and they have to be compatible with MySQLs RLIKE

Igor Serebryany · Accepted Answer · 2009-10-09 10:16:31Z

1

your regexp looks fine - just use NOT RLIKE

answered Oct 9, 2009 at 10:16

Igor Serebryany

3,3413 gold badges32 silver badges43 bronze badges

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

1 Comment

duckyflip Over a year ago

Unfortunately I can't, it's a preset SQL template which I can no change, and I have to use RLIKE

Bart Kiers · Accepted Answer · 2009-10-09 10:58:45Z

1

AFAIK, MySQL's regex library does not support look-aheads, which is necessary for this kind of thing. As already stated, NOT RLIKE seems to be the only option.

edited Oct 9, 2009 at 10:58

answered Oct 9, 2009 at 10:26

Bart Kiers

171k38 gold badges307 silver badges297 bronze badges

Collectives™ on Stack Overflow

Making sure a url parameter is not present, using regex

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related