Hi
I want to get unique records from the database. I am using disting function in select clause but I am not getiing proper output. How to get unique recordes using find_in_set ?
Please help me

Hi,
That only returns the first instance of a string; sounds like you need a different approach. See:
MySQL :: MySQL 5.1 Reference Manual :: 11.4 String Functions (http://dev.mysql.com/doc/refman/5.1/en/string-functions.html)
Peace,
Clarke

DISTINCT returns one record if two or more identical records in the result set exist; it's a dataset function, not a string function.

The primary key's job is to keep each record unique, and if your table doesn't have one, then DISTINCT should work provided each value of each field in each of the duplicate records are the same.

Are you trying to return a single record, or a result set of all unique records? Paste your SQL, it seems like what your trying to do is really basic.

DISTINCT should work, but only if the records are complete duplicates. It might help if you gave us info about your table structure and what is duplicated.