Mysql

---

SELECT phoneno,employee_id, 
    IF(LENGTH(CODE)=20 || LENGTH(CODE)=4,'right_code','wrong_code') 
AS code_status  FROM employee  WHERE created_on >= DATE_SUB(NOW(),INTERVAL 1 HOUR); 
                                     

< How to get last record from table Select query in mysql >

Ask a question

• Question:

  {{questionlistdata.blog_question_description}}

  • Answer:

    {{answer.blog_answer_description  }}

  Replay to Question
  
  

(+91)-9910699802

Become A Member     Become A Teacher