Building a MySQL query with CASE WHEN in it

I'm trying to change "id_board" into "id_type" but I also need to change the numbers...so I need any board id of 4 to become a type_id of 1 (essentially).



I'm hoping someone [url=http://stackoverflow.com/questions/5487892/sql-server-case-when-or-then-e...



Building a MySQL query with CASE WHEN in it