so if i have a list of records... id name other
1 water H2O 2 water aqua 3 water liquid so i want to select other where name = 'water' but i want to only return 1 result, and for that result to be a random value. is there a way to sort by rand() ? or something similar? or am i better of just returning the entire set and writing a function to pick a random value?