How do I perform conditional logic programming(If-Else Statements) in an SQL SELECT?

How do I perform conditional logic programming(If-Else Statements) in an SQL SELECT?

a year ago
Anonymous $5YzO3NGzaX
Last Seen
2 hours ago
Reputation
0
Spam
0.000
Last Seen
3 hours ago
Reputation
0
Spam
0.000
Last Seen
about an hour ago
Reputation
0
Spam
0.000
Last Seen
54 minutes ago
Reputation
0
Spam
0.000
Last Seen
about an hour ago
Reputation
0
Spam
0.000