If I want to query my database with a list of values, such as db Field that contains the values: 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, and 1010...etc. all the way up to 1100.
Instead of listing them individually, "1001, 1002, 1003, 1004, 1005, 1006, 1007...etc is there a way of using regex expressions to shorten these list of values (" 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010 all the way up to 1100") inside the query?
In other words, I don't want to list these values individually, since they are numerous, but rather, wish to shorten it through an expression. Can I use regex for that?
I am thinking "1001 - 1100" (1001 to 1100 in literal terms). Is this correct?
Please might you explain why you intend to use regex for SQL queries instead standard SQL possibilities?
In SQL depending on field type you have these choices:
2. [varchar field] like operator with % placeholder sign.