Ordering Display Results With MySQL Query

[bluewaves]

I am using this mysql code on a php webpage:

 

...WHERE Name LIKE '%hello kitty%' ORDER BY Category

 

What I want to know is this:

 

The field category - is there a way to specify the order in which you want the categories to show up?

Right now, all I know how to do is to alphabetize them ASC or DESC. I would like to be able to

choose the categories display order without it being alphabetized.

 

Thanks.

 

[fenway]

You can use ORDER BY FIELD() if you know the order your want.