Tip #68 Searches Gone Wild! Popular Database Platforms and Their Wildcards
Written by Hilary Kraus and Zahra Premji Take a walk on the wild side! Join us for a deep dive into the world of wildcards. This post provides an introduction to how wildcards work, some potential pitfalls of using them, and detailed information about how to use them in many popular database platforms. Wildcards 101 Complex searching often involves looking for various forms and spellings of a word. One common approach to this is the use of wildcards. There are two varieties of wildcard. A mandatory wildcard replaces one letter; an optional wildcard replaces either zero or one letter. How these wildcards function and what syntax is used to operationalize them depends on where you're searching. In this post, we look at the ways commonly used databases (or database platforms) use wildcards. Going forward, we will use root to refer to a collection of Latin alphabet letters to which a wildcard may be applied. Since wildcards are typically executed using a punctuation mar...