Advertisement
dimuska139

Untitled

Oct 21st, 2021
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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