Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- id as duplicate_id
- from
- users usr1
- where
- id <> 5248022
- and (
- select
- COUNT(*)
- from
- (
- select
- regexp_split_to_table(lower(unaccent(trim(usr1.full_name_pp))) , E'\\s+') as full_name_pp) t1
- inner join (
- select
- distinct regexp_split_to_table(lower(unaccent(trim('Okere Ifeanyichukwu Luther '))) , E'\\s+') as name) t2
- on
- t1.full_name_pp = t2.name) >= 3
- limit 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement