LIKE with wildcard where the string being matched ends with a non-digit 1

[cmayo]

How can I write a query using LIKE with a wildcard where the string being matched ends with a non-digit?

For instance, I need a match on "LIKE 'Stale Ticket #13530%'" which will match the following values:

Stale Ticket #13530
Stale Ticket #13530 | Notice 4

But not these values:

Stale Ticket #135305
Stale Ticket #1353076

In other words, "13530" should only be matched if it's not followed by another digit

 

[feherke]

Hi

Use [tt]regexp[/tt] instead :

ticket [b]regexp[/b] [i][green]'^Stale Ticket #13530([^[:digit:]]|$)'[/green][/i]

Feherke.
feherke.ga

 

[cmayo]

Perfect, thanks feherke. I figured some kind of regex voodoo would do the trick, but I've never had any success trying to learn regular expressions.