Hello! I have a database where values might be things like:
Apple
A_bumblebee
A_chair
Aster
With underscores as part of the name. I want to pull onlythe things that start with "A_", but my query thinks the _ is a wildcard. How do I tell it that I actually want that specific character?
How to identify _ as a character, not a wildcard
in SQL
Posted
Hello! I have a database where values might be things like:
With underscores as part of the name. I want to pull only the things that start with "A_", but my query thinks the _ is a wildcard. How do I tell it that I actually want that specific character?
Thank you in advance!