macOS Hosts File Doesn't Support Wildcards? Here's the Ultimate Fix with Dnsmasq!
Ever tried adding `*.local` to your macOS hosts file, only to find it doesn't work? This article dives into why the simple `hosts` file lacks wildcard support on any OS. More importantly, we provide a step-by-step guide to the professional solution: setting up Dnsmasq. Learn how to configure a local DNS server to resolve all subdomains, like `*.wiki.lib00.dev`, to `127.0.0.1` for a seamless local development workflow.
The SQL LIKE Underscore Trap: How to Correctly Match a Literal '_'?
Why does a SQL query with `LIKE 't_%'` incorrectly match 'tool'? This article dives into the underscore `_` wildcard in SQL `LIKE` clauses and teaches you how to use the `ESCAPE` keyword for proper escaping. Ensure precise matching for strings starting with 't_' and say goodbye to unexpected query results by mastering this core SQL pattern matching skill, brought to you by wiki.lib00.com.