Mysql ORDER BY Question.

[Anon]

Is There a way to order a table from lets say c to b(cdefghijklmnopqrstuvwxyzab)?
This is the code i'm using now:
SELECT * FROM addressbook ORDER BY name;

[badman]

try using where condition alongwith order by..
select * from tbl where name like '%someval%' order by name

maybe it works. if the colname is integer it will certainly work but am not sure about varchar/text.

[[deleted]]

You can do this by creating the order-by information on the fly:

SELECT column,
CASE
WHEN column<'c' then 1
ELSE 0
END AS secondary
FROM table
ORDER BY secondary, column;

This will create a fake column called 'secondary' which will contain 1 if the column value is less than 'c', or zero in all other cases.
So 'a' and 'b' will get 1 in the secondary column, and c-z will get zero.
THen if you order by the secondary column first, and the 'real' column second, you'll get all the zeros first and the ones later.