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 :
userid ; attributeid ; value
1 ; 14 ; 2000-11-29
1 ; 33 ; 11 (or November...)
1 ; 34 ; 29
2 ; 14 ; 2002-06-30
2 ; 33 ; 06 (or June...)
2 ; 34 ; 30
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...
Thanks in advance,