Advertisement
dimuska139

Untitled

Oct 21st, 2021
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. select
  2. id as duplicate_id
  3. from
  4. users usr1
  5. where
  6. id <> 5248022
  7. and (
  8. select
  9. COUNT(*)
  10. from
  11. (
  12. select
  13. regexp_split_to_table(lower(unaccent(trim(usr1.full_name_pp))) , E'\\s+') as full_name_pp) t1
  14. inner join (
  15. select
  16. distinct regexp_split_to_table(lower(unaccent(trim('Okere Ifeanyichukwu Luther '))) , E'\\s+') as name) t2
  17. on
  18. t1.full_name_pp = t2.name) >= 3
  19. limit 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement