Order by

Databases
1

I have a name field in the database. Some of the products also have amperages in their name 12AH LEAD ACID, 1.2AH LEAD ACID, 40AH LEAD ACID

How can I ORDER on these ampere values

2

I was affraid for that :frowning: It’s just that those numeric values in the name only exists in 1 1 out of 12 categories. I have to re-think this one. Thank you for your input

3

One last question about this though. What if there are 2 numeric values in the name for example volt and ampere like 6V 12AH LEAD ACID is it then possible to order on the second numeric value

4

Thank you guelphdad and rudy

5

try this –

ORDER BY product_name + 0
6 
order by ampere + 0
7

no ther isn’t and at that point i’d suggest you need to rethink your table design.

8

Thank you for you reaction. The field ame is not ampere but product_name. For example this is one of the product names:

12AH LEAD ACID

I would like to be able to sort somehow on the ampere part (12AH), so just a part of the product name because there are different amperes