Match fuzzy in MariaDB.

kate_c's profile image kate_c posted 4 years ago in General Permalink

I have two table in Mariadb.

Address: Id | city | street | number | key2_a

Product: Id_prod | name | key2

I would like join TAB address and TAB product:

Id | city|street|number|key2_a|id_prod|name|key2

I'm making a query:

select * from (t1., t2., UTL_MATCH.EDIT.DISTANCE.SIMILARITY(t1.key2_a, t2.key2) SIMILARITY_PERCENT, row_number() over (partiom by t1.id order by UTL_MATCH.EDIT_DISTANCE_SIMILARITY(t1_key2_a, t2.key2)desc)rn_rank from adress t1 join product t1 on UTL_MATCH.EDITSIMILARITY(t1.key2_a, T2.key2)>50)

My error in attachment.

1 attachment(s):
  • error

Please login to leave a reply, or register at first.