Need to have multiple where queries in MySQL query
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
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.
SELECT column_1, AVG(column_2), (AVG(column_2) WHERE column_3 = 'puppies') FROM tablename GROUP BY column_1
|Tags: multiple where, mysql|
|Thread Tools||Search this Thread|
|Similar Threads for: "Need to have multiple where queries in MySQL query"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Optimizing queries in MySQL||Caden Fernandes||Software Development||4||05-03-2010 07:14 PM|
|How to Run MySQL Queries with PHP?||Rob Dizzle||Software Development||4||05-02-2010 05:40 AM|
|Show Number of MySQL Queries||Jagriti||Software Development||3||28-07-2009 03:17 PM|
|Turn on MySQL query cache to speed up query performance||DMA2Superman||Software Development||3||07-07-2009 10:26 AM|
|How can I convert 2 queries into single query||Nutty||Software Development||4||04-05-2009 10:47 AM|