Yes, precisely, that's what I'm looking to accomplish. But I get lost in my 'WHERE' clause since I'm looking to affect 'rows' (attribute 33, and 34) for each userid WHERE attribute 14 is LIKE something. So basically, I want to find :
WHERE attributeid '14' LIKE '%11-29%' (I know this is not how to write it, but I don't know how to write the where clause properly...)
and split this information to SET attributeid 33 = 'month' (will hold month info), and attributeid 34 = 'day' (will hold day info) for any given userid like this :
As I wrote in my original post, I would like to have 2 ways of doing it :
1- in 'targeted' manner (i.e. WHERE attribute 14 LIKE '%11-29%' or LIKE '%-11-%' to target a specific day, or month, etc.)
2- in a full swing for the whole database at the same time if it is feasible to automatically decorticate the yyyy-mm-dd date format (stored as text) to extract the month and SET it to attribute 33 and day and SET it to attribute 34.
I really need some help on this one, although it may be more basic than what I've been looking for and trying...
I'm using mySQL, and I believe it is version 5.0.22, not sure about it but that's the info I see when I access it through Sequel Pro...
Also, when I think about it, I am not sure it is an UPDATE statement that is required, since most of these records (for attribute 33, and 34) do not exist today, they must be created. I've got a few hundreds that exist though, which I had created using Excel and importing into MySQL. But that's the hassle I want to avoid.