Looking for a parseInt() / str_to_int() function...

[Ken]

Is there any built-in funtion at all, that allows us to parse number 
values from strings? This would be a huge aid in getting numeric sorting 
of results;

something like:

select scene, take from movie_table
order by parseint(scene[,10]), scene, ....
-->
sc:8 | tk: ....
sc:a9 | tk: ....
sc:9 | tk: ....
sc:9a | tk: ....
sc:10 | tk: ....
sc:a10 | tk: ....
sc:11 | tk: ....
Historically, i've had to create a separate numeric column for each and 
every string column that needed to first be numeric sorted, and then 
copy the programtically parsed int/long/etc string value to each one, 
strictly to give the desired sort.

thnx!



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]