SQLHUB Telegram 1987
This media is not supported in your browser
VIEW IN TELEGRAM
πŸ–₯ ΠŸΡ€ΠΎΠ΄Π²ΠΈΠ½ΡƒΡ‚Ρ‹ΠΉ SQL-Ρ‚Ρ€ΡŽΠΊ: ΠΊΠ°ΠΊ Π½Π°ΠΉΡ‚ΠΈ строки, ΠΎΡ‚Π»ΠΈΡ‡Π°ΡŽΡ‰ΠΈΠ΅ΡΡ Ρ‚ΠΎΠ»ΡŒΠΊΠΎ ΠΎΠ΄Π½ΠΈΠΌ символом

Иногда Π½ΡƒΠΆΠ½ΠΎ Π½Π°ΠΉΡ‚ΠΈ ΠΏΠ°Ρ€Ρ‹ строк, ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Π΅ ΠΏΠΎΡ‡Ρ‚ΠΈ ΡΠΎΠ²ΠΏΠ°Π΄Π°ΡŽΡ‚ β€” Π½Π°ΠΏΡ€ΠΈΠΌΠ΅Ρ€, ΠΈΠ·-Π·Π° ΠΎΠΏΠ΅Ρ‡Π°Ρ‚ΠΊΠΈ Π² ΠΎΠ΄Π½ΠΎΠΉ Π±ΡƒΠΊΠ²Π΅. Π’Π°ΠΊΠΎΠΉ кСйс часто встрСчаСтся ΠΏΡ€ΠΈ поискС Π΄ΡƒΠ±Π»Π΅ΠΉ Π² ΠΈΠΌΠ΅Π½Π°Ρ…, email ΠΈΠ»ΠΈ Ρ‚ΠΎΠ²Π°Ρ€Π°Ρ….

Π‘ ΠΏΠΎΠΌΠΎΡ‰ΡŒΡŽ Ρ„ΡƒΠ½ΠΊΡ†ΠΈΠΈ levenshtein() ΠΈΠ· Ρ€Π°ΡΡˆΠΈΡ€Π΅Π½ΠΈΡ pg_trgm Π² PostgreSQL, ΠΌΠΎΠΆΠ½ΠΎ Π½Π°Ρ…ΠΎΠ΄ΠΈΡ‚ΡŒ строки, ΠΎΡ‚Π»ΠΈΡ‡Π°ΡŽΡ‰ΠΈΠ΅ΡΡ Ρ€ΠΎΠ²Π½ΠΎ Π½Π° 1 символ. Π­Ρ‚ΠΎ ΡƒΠ΄ΠΎΠ±Π½ΠΎ для очистки Π΄Π°Π½Π½Ρ‹Ρ…, поиска Π΄ΡƒΠ±Π»Π΅ΠΉ ΠΈ Ρ€Π΅Π°Π»ΠΈΠ·Π°Ρ†ΠΈΠΈ "ΡƒΠΌΠ½ΠΎΠ³ΠΎ" поиска Π² интСрфСйсС.


-- УбСдись, Ρ‡Ρ‚ΠΎ pg_trgm Ρ€Π°ΡΡˆΠΈΡ€Π΅Π½ΠΈΠ΅ Π²ΠΊΠ»ΡŽΡ‡Π΅Π½ΠΎ
CREATE EXTENSION IF NOT EXISTS pg_trgm;

-- Найдём строки ΠΈΠ· Ρ‚Π°Π±Π»ΠΈΡ†Ρ‹ users, Ρƒ ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Ρ… name отличаСтся Π½Π° 1 символ
SELECT a.name AS name1, b.name AS name2
FROM users a
JOIN users b ON a.id < b.id
WHERE levenshtein(a.name, b.name) = 1;

-- ΠŸΡ€ΠΈΠΌΠ΅Ρ€: Π½Π°ΠΉΠ΄Ρ‘Ρ‚ ΠΏΠ°Ρ€Ρ‹ Π²Ρ€ΠΎΠ΄Π΅ ('Anna', 'Anya') ΠΈΠ»ΠΈ ('John', 'Joan')


πŸ“ŒΠ‘ΠΎΠ»ΡŒΡˆΠ΅ Π²ΠΈΠ΄Π΅ΠΎ

@sqlhub
Please open Telegram to view this post
VIEW IN TELEGRAM
πŸ‘20πŸ”₯9❀3πŸ‘Ž1πŸ₯°1



tgoop.com/sqlhub/1987
Create:
Last Update:

πŸ–₯ ΠŸΡ€ΠΎΠ΄Π²ΠΈΠ½ΡƒΡ‚Ρ‹ΠΉ SQL-Ρ‚Ρ€ΡŽΠΊ: ΠΊΠ°ΠΊ Π½Π°ΠΉΡ‚ΠΈ строки, ΠΎΡ‚Π»ΠΈΡ‡Π°ΡŽΡ‰ΠΈΠ΅ΡΡ Ρ‚ΠΎΠ»ΡŒΠΊΠΎ ΠΎΠ΄Π½ΠΈΠΌ символом

Иногда Π½ΡƒΠΆΠ½ΠΎ Π½Π°ΠΉΡ‚ΠΈ ΠΏΠ°Ρ€Ρ‹ строк, ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Π΅ ΠΏΠΎΡ‡Ρ‚ΠΈ ΡΠΎΠ²ΠΏΠ°Π΄Π°ΡŽΡ‚ β€” Π½Π°ΠΏΡ€ΠΈΠΌΠ΅Ρ€, ΠΈΠ·-Π·Π° ΠΎΠΏΠ΅Ρ‡Π°Ρ‚ΠΊΠΈ Π² ΠΎΠ΄Π½ΠΎΠΉ Π±ΡƒΠΊΠ²Π΅. Π’Π°ΠΊΠΎΠΉ кСйс часто встрСчаСтся ΠΏΡ€ΠΈ поискС Π΄ΡƒΠ±Π»Π΅ΠΉ Π² ΠΈΠΌΠ΅Π½Π°Ρ…, email ΠΈΠ»ΠΈ Ρ‚ΠΎΠ²Π°Ρ€Π°Ρ….

Π‘ ΠΏΠΎΠΌΠΎΡ‰ΡŒΡŽ Ρ„ΡƒΠ½ΠΊΡ†ΠΈΠΈ levenshtein() ΠΈΠ· Ρ€Π°ΡΡˆΠΈΡ€Π΅Π½ΠΈΡ pg_trgm Π² PostgreSQL, ΠΌΠΎΠΆΠ½ΠΎ Π½Π°Ρ…ΠΎΠ΄ΠΈΡ‚ΡŒ строки, ΠΎΡ‚Π»ΠΈΡ‡Π°ΡŽΡ‰ΠΈΠ΅ΡΡ Ρ€ΠΎΠ²Π½ΠΎ Π½Π° 1 символ. Π­Ρ‚ΠΎ ΡƒΠ΄ΠΎΠ±Π½ΠΎ для очистки Π΄Π°Π½Π½Ρ‹Ρ…, поиска Π΄ΡƒΠ±Π»Π΅ΠΉ ΠΈ Ρ€Π΅Π°Π»ΠΈΠ·Π°Ρ†ΠΈΠΈ "ΡƒΠΌΠ½ΠΎΠ³ΠΎ" поиска Π² интСрфСйсС.


-- УбСдись, Ρ‡Ρ‚ΠΎ pg_trgm Ρ€Π°ΡΡˆΠΈΡ€Π΅Π½ΠΈΠ΅ Π²ΠΊΠ»ΡŽΡ‡Π΅Π½ΠΎ
CREATE EXTENSION IF NOT EXISTS pg_trgm;

-- Найдём строки ΠΈΠ· Ρ‚Π°Π±Π»ΠΈΡ†Ρ‹ users, Ρƒ ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Ρ… name отличаСтся Π½Π° 1 символ
SELECT a.name AS name1, b.name AS name2
FROM users a
JOIN users b ON a.id < b.id
WHERE levenshtein(a.name, b.name) = 1;

-- ΠŸΡ€ΠΈΠΌΠ΅Ρ€: Π½Π°ΠΉΠ΄Ρ‘Ρ‚ ΠΏΠ°Ρ€Ρ‹ Π²Ρ€ΠΎΠ΄Π΅ ('Anna', 'Anya') ΠΈΠ»ΠΈ ('John', 'Joan')


πŸ“ŒΠ‘ΠΎΠ»ΡŒΡˆΠ΅ Π²ΠΈΠ΄Π΅ΠΎ

@sqlhub

BY Data Science. SQL hub


Share with your friend now:
tgoop.com/sqlhub/1987

View MORE
Open in Telegram


Telegram News

Date: |

In 2018, Telegram’s audience reached 200 million people, with 500,000 new users joining the messenger every day. It was launched for iOS on 14 August 2013 and Android on 20 October 2013. Matt Hussey, editorial director of NEAR Protocol (and former editor-in-chief of Decrypt) responded to the news of the Telegram group with β€œ#meIRL.” "Doxxing content is forbidden on Telegram and our moderators routinely remove such content from around the world," said a spokesman for the messaging app, Remi Vaughn. Although some crypto traders have moved toward screaming as a coping mechanism, several mental health experts call this therapy a pseudoscience. The crypto community finds its way to engage in one or the other way and share its feelings with other fellow members. Earlier, crypto enthusiasts had created a self-described β€œmeme app” dubbed β€œgm” app wherein users would greet each other with β€œgm” or β€œgood morning” messages. However, in September 2021, the gm app was down after a hacker reportedly gained access to the user data.
from us


Telegram Data Science. SQL hub
FROM American