View Full Version : regex

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 ?

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


EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum