case when then in mysql


gender = column name

table = table name



SELECT * ,

CASE   gender when 'm' then 'male'
              when 'f' then 'Female'   else gender
END as ty



FROM  Table









SELECT * ,

CASE  when   id > 5   then 'male'
              when   id < 5   then 'Female'   else gender
 END as ty



FROM  Table




Comments

Post a Comment

If you Satisfied , Please Leave a comment

Popular posts from this blog

Call PHP Function In JavaScript Using Ajax

how to call php function from javascript function 1. create Folder on WWW Or htdocs (on your computer) 2. create index.php page on your folder and paste this code index.php <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>  <script> function addsearchproduct(x){   // this is JavaScript  function    $.ajax({   type: 'POST',   url: "function.php?f=phpFunction&p="+x,          // call php function , phpFunction=function Name , x= parameter     data: {},   success: function(data1){         alert(data1);   } });             } </script> <input type="button" value="call Php Function" onclick="...
Read more

List of Post Category Wise in wordpress

for example show this type Category 1   post1    post 2    post3 category 2    post 1    post 2 Category 3   post1    post 2    post3  code : <?php // get all the categories from the database    $cats  =  get_categories (); // loop through the categries   foreach ( $cats  as  $cat ) {   // setup the cateogory ID    $cat_id =  $cat -> term_id ;   // Make a header for the cateogry    echo  "<h2>" . $cat -> name . "</h2>" ;   // create a custom wordpress query   query_posts ( "cat=$cat_id&post_per_page=100" );    // start the wordpre...
Read more

PHP Script for sending mail with attachment file

send email with attachment in php  code to send email with attachment in php  form.html <form action="sendmail.php" > <label> Name:</label> <input type="text" name="name" id="name" /> <label> email:</label> <input type="text" name="email" id="email" /> <label> Phone No:</label> <input type="text" name="ph" id="ph" /> <label> Message:</label> <input type="text" name="msg" id="msg" /> <label> Resume :</label> <input type="file" name="txtresume" id="txtresume" /> <input type="submit" name="send mail" value="send mail"  /> </form> sendmail.php <?php error_reporting ( 0 ); //ini_set('display_errors','off'); //ini_set('memory_limit', '-1'...
Read more