UPDATE and INSERT in one

[lists]

Hi,

I want to update a table if it meets some conditions (already exist)  
and INSERT otherwise?

Right now I am doing it this way:

1. SELECT the record
2. If it exist, I UPDATE it
3. If it does not exit, I INSERT a new record

Could this be done in one query? I mean like conditional update/insert?

/Peter