[RESOLVED] FIND_IN_SET Question

[tito]

Hello,

I have a table A which contains a field with those text values

option1,option2,option3 etc...

All those options are created from another table B options. They are inserted when someone selects one or more FROM B to A.

Problem is from time to time the original name, example option2 could be changed to mynewoption in master table B

How can I use FIND_IN_SET to locate oldname (option2) and replace it with mynewoption in table A? Or what is the better way to do it?

I usually use ID but in that case I must use text, and updating a name causes havoc.

Thank you.

[bradgrafelman]

tito wrote:

Or what is the better way to do it?

A (much) better way of doing it would be to normalize your DB schema.

In other words, don't store multiple values in the same field. Instead, store each selection in a separate row. The details really depend on your application and the data you're working with. I'd recommend you start by reading a good article or two on database normalization, though.

[tito]

Those are custom fields, created on the fly. Then for some of them, like multiple selections I assign options to them. Those options are each one in their row, and when it's time to populate one row of custom field you store data1 in field1, data2 in field3 but field3 so happen to have multiple options. I had to choose between serializing them and storing them or storing them as one,two,three. At retrieving them I simply explode $row[field3] into an array and foreach I go to correspnding option table to get that option detail, such as an image. Storing them in their row within that row would have created a mess.

[tito]

Never mind. I was able to do it.