I would like to write a MySQL query that will limit the selected records to a specific pattern that end in digits rather than non-numeric characters.
Say the field (TESTPHASE) has values like this
I want the SELECT query to return only
I suppose it would be possible to filter these after the fact with some fancy php code, but I'd MUCH rather do it up front with the MySQL query.
Oh, and of course I am stuck with MySQL v3.23.45