wildcard - Picking columns with certain amount of letters with potential numbers on top (SQL)

Question

I have a school assignment in which I have an SQL database that has rows with numbers. I'm supposed to do a command which deletes all the columns that begin with 1, have three numbers and potentially has letters on top. This means that some of these have a value like "110P" or something like that, and im supposed to delete them as well. LIKE "1_%_%" however also picks values like "14K" which do not apply.

How do I code

question from:https://stackoverflow.com/questions/66063235/picking-columns-with-certain-amount-of-letters-with-potential-numbers-on-top-sq

Answer 1

Waitting for answers