...

View Full Version : regex



BubikolRamios
04-11-2013, 09:15 AM
select distinct(field)
from fixed_table
WHERE data not REGEXP '^(-|+){0,1}([0-9]+.[0-9]*|[0-9]*.[0-9]+|[0-9]+)$';


This was working, no change for 3 months.
now I suddenly get:
SQL Error (1139): Got error 'repetition-operator operand invalid' from regexp


Any advice ?

BubikolRamios
04-11-2013, 11:57 AM
Something wrng with server or client, code got changed from upper good to lower corrupt.



'^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'
'^(-|\+){0,1}([0-9]+\.[0-9]*|[0-9]*\.[0-9]+|[0-9]+)$'



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum