SELECT only unique records

I am sure this is a slam-dunk, but I am new to this and stumped ... thanks. I have the following statement, but I need it to pull only unique listings - I get repeated items. SELECT state_ID FROM financial_master WHERE category_ID = '1'

how to do a random ORDER BY in a SELECT statement

I am querying a table and using the following statement: SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY name I would like to ORDER BY RANDOM - is there an easy way to do that. Thanks. -Doug

Compiling on Solaris 2.6

I have tried multiple times to build a version of 3.23.55 with support for innodb under Solaris 2.6. I can not upgrade the version of the OS. Here is the error: source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/ksh ../depcom