Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. SELECT '10-5' REGEXP '10-5' as temp;
  2. SELECT '10/5' REGEXP '10/5' as temp;
  3. SELECT '1*5' REGEXP '1*5' as temp;
  4.  
  5. SELECT '10+5' REGEXP '10+5' as temp;
  6. SELECT '10*5' REGEXP '10*5' as temp;
  7.  
  8. SELECT '10+5' REGEXP '10\+5' as temp;
  9. SELECT '10*5' REGEXP '10\*5' as temp;
  10.  
  11. SELECT '1*5' REGEXP '1*5' as temp;
  12.  
  13. SELECT '10*5' REGEXP '10*5' as temp;
  14.  
  15. 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