Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. SELECT *
  2. FROM freelook
  3. WHERE done_type IN ('14','27','28')
  4.  
  5. ...
  6. WHERE
  7. done_type = '14'
  8. OR done_type LIKE '14,%'
  9. OR done_type LIKE '%,14'
  10. OR done_type LIKE '%,14,%'
  11.  
  12. SELECT *
  13. FROM freelook
  14. WHERE done_type LiKE '%14%'
  15. OR done_type LiKE '%27%'
  16. OR done_type LiKE '%28%'
  17.  
  18. SELECT *
  19. FROM freelook
  20. WHERE REGEXP_LIKE(done_type, '[^14,|,14,|,14$|^27,|,27,|,27$|^28,|,28,|,28$|]')
  21.  
  22. SELECT *
  23. FROM freelook
  24. WHERE REGEXP_LIKE(done_type, '^14,27,28$')
  25.  
  26. WITH tokens as (
  27. SELECT distinct id, token
  28. FROM
  29. (SELECT
  30. id,
  31. SUBSTR (csv,
  32. INSTR (csv, ',', 1, LEVEL ) + 1,
  33. INSTR (csv, ',', 1, LEVEL+1) - INSTR (csv, ',', 1, LEVEL) -1
  34. ) AS token
  35. FROM (
  36. SELECT id, ','||trim(done_type||',') csv FROM freelook)
  37. CONNECT BY LEVEL <= LENGTH(csv)-LENGTH(REPLACE(csv,',',''))+1)
  38. WHERE token is not NULL)
  39.  
  40. SELECT id FROM tokens
  41. WHERE token in ('14','27','28')
  42. ORDER BY id, token
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement