I have two fields in a table - yearcon and yearren.
select yearren, yearcon from property
If yearren is populated I want to look at that field in the where statement and if not, look at the yearcon field.
where if(yearren > 0, yearren, yearcon) > 2000
Can someone help me? I have the flu and my brain doesn't work!