Wildcard Character

noun

say it: “WYLD-kard KAR-ik-ter” /ˈwaɪldkɑːrd ˈkærɪktər/

A symbol in a text pattern that stands for unknown characters, such as % or _ in SQL's LIKE.

What is Wildcard Character in a relational database?

Wildcard Character — A pattern character representing unknown text, such as % or _ with LIKE.

SELECT customer_id, email
FROM customer
WHERE email LIKE '%@example.com';

In a sentence

  • “The wildcard % in 'Ch%' matches any characters after Ch.”

Level: Apprentice · More SQL terms at this level

Updated