hi there i have a mysql database populated with products, each product has a product code the product code contains letters and numbers eg. TL541 , TL75 etc

my client wants the products ordered by code, but TL541 comes before TL75 presumably because 5 is lower than 7

sayısal sırayla bu sipariş için nasıl bir fikir?