MySQL: Choose something different if select does not return any rows

SELECT timestamp FROM table WHERE id = '10'

Is it possible to get the SELECT above to return a timestamp of '0000-00-00 00:00:00' if there is no id of '10' in the table?

---

Yes...

Use an If Exist / else statement. Your else can return the timestamp.