How can I set a numeric wildcard in MySQL?
I am a SQL newbie, and I am trying to create a SQL script that finds codes in two different databases. I want to set a parameter that has a numeric wildcard. Codes are often written like this for example, “ABC108”, “ABC109”, “DEF47213”, etc. I set the parameter as ‘ABC[0-9]+’ to return all possible variations of codes that start with ABC, but that resulted in a blank output.