468,483 Members | 2,689 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,483 developers. It's quick & easy.

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

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.

Dec 14 '13 #1
1 859
288 256MB
instead of date='%Tuesday%' put date like '%Tuesday%' or date='Tuesday'
Dec 16 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Hareth | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.