Mysql regexp prevent character being number

Question

Can someone help me with this bug. I need the following code to NOT match if there is another number afterwards

$query = "SELECT * FROM mytable WHERE server_name REGEXP '(server ?" . $server_id . ")' ";

For example, if $server_id is 50, it currently matches server 500, 501 etc and I dont want it too, but it should be allowed to match 'server50' 'server50 100mbit' 'server50,100mbit' etc. the character afterwards needs to be anything other than another number and can even be nothing at all.

Stu

Ja͢ck · Accepted Answer · 2012-07-02 19:36:48Z

1

Matching a non-digit is [^0-9] in regular expressions.

$query = "SELECT * FROM mytable 
    WHERE server_name REGEXP 'server ?" . $server_id . "([^0-9]|\$)' ";

edited Jul 2, 2012 at 19:36

answered Jul 2, 2012 at 19:19

Ja͢ck

174k39 gold badges269 silver badges317 bronze badges

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

1 Comment

Programster Over a year ago

does that work if there is nothing at the end? e.g its just 'server50'?

Fallenreaper · Accepted Answer · 2012-07-02 19:24:11Z

You will want to do a regex against a number. /^0-9/ and what you would then need to do is to if returns a match, you need to say "Hey now, thats a number, wrong!" whereas if it returns an empty set, it would be a match.

You can also do a regex against it NOT being a number, where as you put the NOT character inbetween the ^ and the [.

I forget NOT syntaqx off the top of my head at the moment, but in common lingo, it would look like /^![0-9]/

the slashes are usually the sign of a regex.

with your stuff, you need to do something like /^serverid[0-9][0-9]/ which will compare the regex with SERVERID[][] so it will only read the first 2 characters. If there are MORE characers, you can boot it out, or things like that

Collectives™ on Stack Overflow

Mysql regexp prevent character being number

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