By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,101 Members | 1,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,101 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Dec 14 '13 #1
Share this Question
Share on Google+
1 Reply


Exequiel
100+
P: 287
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.