Need to have multiple where queries in MySQL query
Hello,
I have some queries for mysql but I don't know how to form them because they are really complex & I hope if we can have multiple where clause in a single query.
easy way to check if a condiction has multiple possible values
If you can help me with constructing multiple where clause in single statement It will solve my problem.
If its possible please head me towards a good tutorial please.
Re: Need to have multiple where queries in MySQL query
Hello friend,
Even I need to know how can I have multiple cases in a single statement using where clause like as follows.
This is what i need to do.
Code:
SELECT column_1, AVG(column_2), (AVG(column_2) WHERE column_3 = 'puppies')
FROM tablename GROUP BY column_1
I hope someone will come up with the solution.
