Hi,
I just converted an excel sheet to mysql wich covers the hotels stop sales at this moment the table is built this way:
| Day | Hotel | ID | Parsed_date |
| 1 MAY 2007 1
BAYSIDE 2
SHERATON 3
BEST WESTERN 4
2 5
Bayside 6
Sheraton 7
1 JULY 2007 40
Bayside 41
Sheraton 42
2 43
Sheraton 44
Best western 45
What i want to do is write on the column " parsed_date " the date associated to each hotel in this case ID numbers: 1,2,3 and 4 on the Parsed_date column shoub be 1 MAY 2007.
since on the "Day" column has no data i have to identify the first number that shows up and write the correct date to the "Parse_date" column" when it comes another day like "2" it writes 2 May 2007 and also when it changes to month of july it writes.
I have tryed make several ways to approach this but i wonder if someone can help me with this .
Thank you
Pedro
