Here I explain CASE and WHEN condition with MySQL select query.
MySQL Example:
SELECT CASE
WHEN STATUS_FLAG=1 THEN ‘Yes’ ELSE ‘No’
END AS STATUS_FLAG
FROM TABLE1
Enjoy!
Subscribe to:
Post Comments (Atom)
1980s Photo Prompts: Easy Online Copy & Paste
Are you on a quest to enhance your photography projects with a touch of nostalgic flair? Look no further than 1980s photo prompts. These car...
-
Put this code between <head>...</head> tag. <script type="text/javascript"> function readURL(input) { ...
-
Yes, normally datatable Ajax file call outside of AngularJs folder structure, If you define ng-click there then it’s not working in An... -
Using PHP to upload files into MySQL database sometimes needed by some web application. For instance for storing pdf documents or images to ...
No comments:
Post a Comment