Guest User

Untitled

a guest
Jul 17th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. SELECT t.*
  2. FROM YOUR_TABLE t
  3. WHERE t.column LIKE '123-%'
  4. OR t.column LIKE '123_%'
  5.  
  6. SELECT a.*
  7. FROM YOUR_TABLE a
  8. WHERE a.column LIKE '123-%'
  9. UNION ALL
  10. SELECT b.*
  11. FROM YOUR_TABLE b
  12. WHERE b.column LIKE '123_%'
  13.  
  14. select * from foo where bar regexp '^123-|_'
  15.  
  16. SELECT * FROM table
  17. WHERE field like "123"
  18. OR field LIKE "123-%"
  19. OR field like "123_%";
  20.  
  21. select * from table where field regexp '^[1-9]{3}[_-]';
Add Comment
Please, Sign In to add comment