I'm trying to use this with a where clause, but I can't just seem to get the hang of it. I also can't find many good examples online. I understand that there are two different versions, but I'm not sure which one suits my problem the best.

What I'm trying to achieve to make a where clause dependent on the value of a column. Something like this in pseudo code:

where car.brand = 'SAAB' when car.country = 'Sweden'

I hope that makes sense. Are anyone experienced in using these and can help me out with some examples?

I think I have found the answer myself, after some further digging online. Something like this:

where car.brand = case when car.country = 'Sweden' then 'SAAB' (else whatever) end