Query help.

[kpowning]

I have a table named "extra_field_values" it has three columns

(productid, fieldid, value)

if fieldid = 6

then value holds comma seperated names for each productid.

I'm trying to query the database and get all names but I dont want names that might appear in another row if its the same name. So just unique names from all rows as a whole. What is the best way to do this?

Thanks In Advance 🙂

[Weedpacket]

kpowning wrote:

What is teh best way to do this?

Don't store the names in a comma-separated string; use a proper relation (it's a relational database, after all). Then it would be a matter of "SELECT DISTINCT name FROM ...".

[kpowning]

Problem is I didnt create it - its my ecommerce site. They set it up this way. Should I complain since they just got paid to integrate my datafeed and there saving this information that way in mysql? Whats your opinion?

[kpowning]

x-cart btw is the ecommerce software.