[ Solved ] ordering mysql result

[oracle259]

How can i order my mysql result by the length of the word
eg

say i have the following words in my db

string
stringest
stringer

how can i get the mysql to search through the db and produce results in the following order

stringest
stringer
string

[tleisher]

Use usort(), and create a function like this:

function sort($a, $b)
{
    if(strlen($a) > strlen($b))
    {
          $a = 1;
    }
    else
    {
          $a = -1
    }
}

[oracle259]

I tried that but can it be done in the mysql command itself

like SEARCH * FROM table ORDERBY ***

[simcoweb]

It would be ORDER BY then the column you want it sorted with... like 'id' or similar.

[tleisher]

ORDER BY needs a column to order from, you may be able to do ORDER BY `name` but Im not sure if it would work, give it a shot and find out.

[.josh]

select * from table order by length(columnname)

[oracle259]

Thanks this one is solved