Re: "Order By" on a text field

[Felix Geerinckx]

yann.luppo wrote:

> I have a table with a primary key field (idField) declared as varchar(64). I did so because most of
> the time the key stored is going to be a numeric but sometimes it can be a some kind of small
> Text.
>
> But now I'm facing some issues trying to order by "idField" asc.


SELECT idField FROM atable ORDER BY idField REGEXP "^[^0-9]", idField+0, idField

to get the text ones at the end.

Change the regular expression to "^[0-9]" if you want the text ones upfront.

--
felix
Please use BBCode to format your messages in this forum.