add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT '123456' REGEXP '(^123[0-9]+$)|(^9876[0-9]+$)|(^56789012$)'
'123456' REGEXP '(^123[0-9]+$)|(^9876[0-9]+$)|(^56789012$)'
1
SELECT CASE
WHEN '123456' REGEXP '^123[0-9]+$' THEN '^123[0-9]+$'
WHEN '123456' REGEXP '^^9876[0-9' THEN '^9876[0-9'
WHEN '123456' REGEXP '^56789012$' THEN '^56789012$'
ELSE
'no pattern'
END
CASE
WHEN '123456' REGEXP '^123[0-9]+$' THEN '^123[0-9]+$'
WHEN '123456' REGEXP '^^9876[0-9' THEN '^9876[0-9'
WHEN '123456' REGEXP '^56789012$' THEN '^56789012$'
ELSE
'no pattern'
END
^123[0-9]+$