Select very specific wildcards
Hi there. There are so many forums, I' not sure this is in the right place, I apologise if it isn't.
I have a need to run a load of select queries that need to pattern match strings in fields. An example would be [model=p345 [type]=df7854gv3
I need to select * from [table] where [model] match 'ANNN'
And select from [table] where [type] match 'AANNNNAAN'
Where A matches an alpha character and N matches a numeric character.
I've been through all the wildcard and matching articles and I can find and I can't find what I need. Surely there is a placeholder for numeric and alpha?
Many thanks.
Subject
Written By
Posted
Select very specific wildcards
November 28, 2018 07:45AM
November 28, 2018 12:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.