3 ms·
Underscore matches any single char, so those patterns work fine. It’s an efficient way to match any small separator, like space, dashes, etc.
by talkin 5y ago
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 5y agoI didn't know _ is a metachar in LIKE expressions, thanks! Not the first time its syntax caught me off-guard.
- CRConrad 5y agoIt only has two, doesn't it? Underscore for "any single character", and percent for "any string of characters", AFAIK.