Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT '10-5' REGEXP '10-5' as temp;
- SELECT '10/5' REGEXP '10/5' as temp;
- SELECT '1*5' REGEXP '1*5' as temp;
- SELECT '10+5' REGEXP '10+5' as temp;
- SELECT '10*5' REGEXP '10*5' as temp;
- SELECT '10+5' REGEXP '10\+5' as temp;
- SELECT '10*5' REGEXP '10\*5' as temp;
- SELECT '1*5' REGEXP '1*5' as temp;
- SELECT '10*5' REGEXP '10*5' as temp;
- A REGEXP pattern match succeeds if the pattern matches anywhere in the value being tested. (This differs from a LIKE pattern match, which succeeds only if the pattern matches the entire value.)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement