undefined | Better HN

0 pointsformerly_proven4y ago0 comments

Bunch of ineffective entries too, all patterns containing underscores won't ever match.

0 comments

3 comments · 1 top-level

talkin4y ago· 2 in thread

Underscore matches any single char, so those patterns work fine. It’s an efficient way to match any small separator, like space, dashes, etc.

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

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

j / k navigate · click thread line to collapse