php - 1a 1b 1c level descriptors in mysql -

php - 1a 1b 1c level descriptors in mysql -

how build dynamic mysql query value of max(invoiceno) should

1a,1b,1c...1z,2a,2b...2z,3a...

the query

$max = "select max( invoiceno ) invoicenomulti invoice_balance";

here fiddle

try

select invoiceno invoice_balance order invoiceno asc limit 3

this query homecoming 1a,1b,1c

php mysql