Underscore matches any single char, so those patterns work fine. It’s an efficie... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		talkin on Oct 7, 2021 \| parent \| context \| favorite \| on: The naughty username checking system used by Twitc... Underscore matches any single char, so those patterns work fine. It’s an efficient way to match any small separator, like space, dashes, etc.

formerly_proven on Oct 7, 2021 [–]

I didn't know _ is a metachar in LIKE expressions, thanks! Not the first time its syntax caught me off-guard.

CRConrad on Oct 10, 2021 | [–]

It only has two, doesn't it? Underscore for "any single character", and percent for "any string of characters", AFAIK.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact