MySQL Forums
Forum List  »  General

Select very specific wildcards
Posted by: Tull Clancey
Date: November 28, 2018 07:45AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Select very specific wildcards
November 28, 2018 07:45AM


Sorry, only registered users may post in this forum.

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.