How to include an IF() statement in SQL?

How do I include a condition within a select statement? Something like the following (only one that works):

select if(customers.custid=customers.parentid,'',customers.name) as parent_name from customers;

Troy Perchotte Received on Tue Sep 01 1998 - 00:00:00 CDT