Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 03-07-2009
Member
 
Join Date: Apr 2008
Posts: 32
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.
Reply With Quote
  #2  
Old 03-07-2009
Member
 
Join Date: Oct 2008
Posts: 116
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 12:08 PM.