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)
The Future of Technology: Emerging Trends to Watch in 2025
Introduction As we navigate through 2025, the technological landscape continues to evolve at an unprecedented pace. Innovations that once se...
-
Put this code between <head>...</head> tag. <script type="text/javascript"> function readURL(input) { ...
-
$no = 5; $no2 = 10; $no3 = 6; $maxVal = max($no,$no2,$no3); echo $maxVal; Result: 10
-
If you want to change page title from admin side then please follow below steps: * Login in admin and open CMS > Static pages, th...
No comments:
Post a Comment