I am having a problem with my syntax for the following code:
What I am trying to do is:
1. Check if sticky = 'y' then give a value of 1
2. If not then check whether announcement is 'y' then give a value of 2
3. If not then check whether announcement is 'a' then give a value of 3
4. If none of the above give a value of 0
I think one of my problems is changing from looking at sticky to announcement but there may be something more funamental.
INSERT INTO topics ( topic_type ) SELECT t.sticky WHEN 'y' THEN 1 t.announcement WHEN 'y' THEN 2 t.announcement WHEN 'a' THEN 3 ELSE 0 END AS topic_type FROM setup t;