How to use alias column name in where clause

How to use alias column name in where clause - Mysql

Example
SELECT name,count (*) AS count FROM `emp` WHERE count <5

Instead of the above use
SELECT name, count(*) AScount FROM `book` WHERE condition HAVING count <5
Instead of WHERE clause use HAVING clause.

Comments

Jquery form validation with ajax request

Include library <script src = "js/jquery.min.js" ></script> <script src = "js/jquery.validate.js" ></script> <?php $_SESSION [ 'code' ]= rand ( 1000 , 2000 ); ?> <form name = "form-signup" id = "form-signup" method = "post" > <table width = "50%" > <tr> <td> Name </td> <td><input type = "text" name = "name" id = "name" class = "change" ></td> </tr> <tr> <td> Email </td> <td><input type = "text" name = "email" id = "email" class = "change" ></td> </tr> <tr> <td> Username </td> <td><input type = "text" name = "username" id = "username" class = "chan...

PHP+AJAX+MYSQL: Sort & Save using Drag & Drop (TABLE TR)

" Drag, Drop, Sort, Save " Drag & Drop : Move the draggable element by clicking on it with the mouse and dragging it anywhere within the viewport. Sor t: The sort order can be either alphabetic or numeric, and either ascending or descending. Here we had created demo that allow the user to drag and drop elements and quickly and save them with PHP + MySQL+ AJAX +JQUERY on the server side. Table of content 1) Drag and drop element on every click 2) Sort data on the server side using PHP+MYSQL 3) Great user interface and easy to execute with a few lines of code

Select Insert Update Delete With Image In Php MySQL

CRUD with image upload is a very common task in web development ( CRUD stands for Create/Read/Update/Delete ). The main purpose of a CRUD is that enables user’s create/read/update/delete data using PHP & MYSQL. Table of Content Create Database Insert Record with image upload Show Record Edit Record Delete Record

Programming Tutorials On PHP,ASP.NET,AJAX,JQUERY,HTML

Search This Blog