Results for “like”
Small, practical examples. Search by task or narrow things down below.
Match a text prefix
SQLite: Use a percent wildcard after a known prefix.
SQLite✓ Tested
Search text without case sensitivity
Match a pattern with PostgreSQL ILIKE.
ILIKE✓ Tested
Compare two generated sorted streams
Bash Scripts: Process substitution lets a command consume another command’s output as a file-like input.
Bash Scripts✓ Tested
Count Unicode code points in a string
JavaScript: String iteration combines surrogate pairs, unlike the UTF-16 length property.
JavaScript✓ Tested
Count Unicode code points in a string
TypeScript: String iteration combines surrogate pairs, unlike the UTF-16 length property.
TypeScript✓ Tested
Move overlapping bytes safely
C: memmove supports overlapping ranges, unlike memcpy.
C✓ Tested
Preserve line breaks while collapsing repeated spaces
CSS: Pre-line retains newlines but does not preserve all whitespace like pre-wrap does.
CSS✓ Tested
Rank tied scores with competition gaps
SQL: RANK leaves a gap after tied rows, unlike DENSE_RANK.
SQL✓ Tested
Rank tied scores with competition gaps
SQL Server: RANK leaves a gap after tied rows, unlike DENSE_RANK.
SQL Server✓ Tested
Rank tied scores with competition gaps
Postgres: RANK leaves a gap after tied rows, unlike DENSE_RANK.
Postgres✓ Tested
Rank tied scores with competition gaps
SQLite: RANK leaves a gap after tied rows, unlike DENSE_RANK.
SQLite✓ Tested
Search a small FTS5 table
Use SQLite’s full-text index to match a term.
FTS5✓ Tested