Hi,

> I have query like this :
> "select content_id, title from content_language where content_id in (12,
> 11)"
>
> then it always display the content_id order by content_id, if i want to

not

> order , how ?

What order do you want ?
There's no order specified in your query thus the order is accidental in
this order.

Use the ORDER BY clause to order as you want :

SELECT
content_id,
title
FROM
content_language
WHERE
content_id IN (12,11)
ORDER BY
title, content_id

Regards,
Arno