Populate empty field1 with specific text if that text found in field2

[bjcdrama]

I'm trying to look for day of week (i.e. 'Mondays') in a given description of a course which resides in field 'date' and place that day ('Mondays') in a new field 'day'.

In such a way we can easily check for conflicts. But I keep getting error.

UPDATE wint14 SET day = 'Tuesdays' WHERE date = '%Tuesdays%'

I'm a total amateur but I don't see why this doesn't work.

bjc

[Exequiel]

instead of date='%Tuesday% ' put date like '%Tuesday%' or date='Tuesday'