cant get a random mysql selection going :(

[eluser]ommy[/eluser]
Hi there,
I ran into a problem trying to use the order_by:random method. It's probably something stupid i'm not seeing on this goofy saturday. But a lot of googling and reading up on the distinct, mysql, php etc. didnt help yet.

I'm taking the leap and asking here. There's bound to be someone here kind enough to point out my ignorance

ps: This is the error codeigniter/mysql is spitting out:

Code:

A Database Error Occurred
Error Number: 1054
Unknown column ' RAND() LIMIT 1' in 'order clause'
SELECT DISTINCT * FROM (`gallery`) WHERE `active` = 1 AND `public` = 1 ORDER BY ` RAND() LIMIT 1

Thanks in advance for any help!
Tommy