SQL WILDCARD Characters

SQL WILDCARD Characters is a SQL clause in the SELECT Queries category. Wildcard characters for pattern matching with LIKE. Different databases support different sets. The syntax is LIKE pattern - percent(any) underscore(one char). It returns pattern matching result. A typical example: _ (underscore): matches exactly one character LIKE _at matches: cat, bat, hat % (percent): matches any sequence LIKE %at% matches: cat, batter, at [charlist] (SQL Server only): LIKE [abc]at matches: cat, bat LIKE [a-c]at matches: cat, bat Escape (literal wildcard): LIKE 100% ESCAPE \ matches 100% exactly A close relative is SELECT, which retrieves data from a table. The most fundamental SQL statement. A close relative is SELECT *, which selects all columns from a table. A close relative is SELECT DISTINCT, which returns only distinct (unique) values from the specified columns. More about this category: Core SELECT query clauses — SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT.