Mysql Mysqlworkbench Substring Invoicenumber 3 2 Thirdfourth Statement Needed Return Third Q37105092

MYSQL from MYSQLworkbench :

So,

SUBSTRING (invoice_number, 3,2) as thirdFourth

is the statement needed to return the third and fourthcharacters of invoice number, but i also need a WHERE to return thenumber only if it has a 9 or 2 in it. For example:

989319-467 = 93

P-0259 = 02

98319-417 = 93

P-0608 = 06 <—- so rows like these do not return.

Please let me know if you require more information.

Edit 1. Its 93

Solution