SQL 'LIKE' query using '%' where the search criteria contains '%'
When you're using SQL's LIKE operator and your search term includes the % character, it can get a bit tricky because % is a wildcard in SQL. It matches any number of characters, so if you're trying to find a literal % in your data (like a discount field with values such as 10%), you’ll need to escape the % character.…
Answered May 18, 2025 · 1.8K Views Read answer →