Pages
Home
My Zend Framework CMS
Creating a datagrid in Zend Framework
My Portfolio
Friday, February 10, 2012
How to use 'case' in mysql query
select id, case report.type when 'P' then amount when 'N' then -amount end as amount
from `report`
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment