How to order 1,2,3 instead of 1, 10, 11, 12 in MySQL when the column to sort by is a string?

The following query gets results ordered like: 1, 10, 11, 12, 2, 3

I want my results sorted like 1, 2, 3, [...], 9, 10, 11...

SELECT P.*, C.Name AS CatName 
FROM products AS P 
LEFT JOIN categories C ON C.id = P.category_id'

mysql sql-order-by

Edit Report

0 Answers