I'm trying to retrieve a record ORDER by id ASC...
Posted: Mon Aug 09, 2004 12:54 pm
I'm trying to retrieve a record ORDER by id ASC, but my field is of the form:
x0000000000
where x is a letter.
Is there a MySQL command to ignore the first letter? Or does MySQL already consider A2 to be bigger than A1?
x0000000000
where x is a letter.
Is there a MySQL command to ignore the first letter? Or does MySQL already consider A2 to be bigger than A1?