Posted by Martin Larsen on 11/11/06 19:39

Yobbo wrote:

> I don't want this bloody order I want 6,20,234,19,32,4,800,177!!
>

Funny --- I came here right now to ask exactly that question! Although I
didn't find a answer, I somehow got inspired. Strange ...

Here is the solution:

SELECT STRINGTEXT, TOKENID
FROM WEBSTRINGS
WHERE TOKENID IN (6,20,234,19,32,4,800,177)
ORDER BY FIELD(TOKENID, 6,20,234,19,32,4,800,177)

You have to repeat the set but that's easily done in PHP.

Best regards,
Martin

[Back to original message]