Click to copy
Working With Strings • Reviewed for ksqlDB 0.29
How to Compare Two Strings Case Insensitive in ksqlDB
To compare two strings ignoring the differences in
lowercase and uppercase,
use the LCASE() on both strings:
SELECT name
FROM products
WHERE LCASE(category) = LCASE('FuRnItUrE')
Was this article helpful?