MySQL Forums
Forum List  »  Optimizer & Parser

Query Optimization
Posted by: Praveen Kumar
Date: June 15, 2009 06:07AM

Hi,

I have a table structure like below.

Flyer_data_field_values

ID
FLYER_ID
Field_id
Value

Sample data is

2872011 | 368131 | 309 | Accord
2872012 | 368131 | 311 | Honda
2872013 | 368131 | 313 | Black
2872014 | 368131 | 308 | 102849
2872015 | 368131 | 307 | 4491.0 usd
2872016 | 368131 | 310 | 1997
2872017 | 368131 | 314 | Vast.com
2872018 | 368131 | 315 | North Canton, OH, 44720, United States
2872019 | 368131 | 316 | http://www.vast.com/detail/cars/ob-

2872020 | 368132 | 309 | Accord
2872021 | 368132 | 311 | Honda
2872022 | 368132 | 313 | BLACK
2872023 | 368132 | 312 | 4dr Sdn EX Auto V6 Sedan
2872024 | 368132 | 308 | 124805
2872025 | 368132 | 307 | 4988.0 usd
2872026 | 368132 | 310 | 1997
2872027 | 368132 | 314 | eBizAutos.com
2872028 | 368132 | 315 | Highland, IN, 46322, USA
2872029 | 368132 | 316 | http://thomas-dodge-online.ebizautos.com

2872002 | 368130 | 309 | Celica
2872003 | 368130 | 311 | Toyota
2872004 | 368130 | 313 | Red
2872005 | 368130 | 308 | 114907
2872006 | 368130 | 307 | 5991.0 usd
2872007 | 368130 | 310 | 1993
2872008 | 368130 | 314 | Vast.com
2872009 | 368130 | 315 | Libertyville, IL, 60048, United States
2872010 | 368130 | 316 | http://www.vast.com/detail/cars/ob-

Here I want to have one optimized query which will find content of value field of 308 and 307(field_id) where 311=Toyota 309 = Celica and 310 = 1993

I want result as this

2872005 | 368130 | 308 | 114907
2872006 | 368130 | 307 | 5991.0 usd

with the following criteria

311=Toyota 309 = Celica and 310 = 1993

Can some one help me.

Options: ReplyQuote


Subject
Views
Written By
Posted
Query Optimization
3926
June 15, 2009 06:07AM
2212
June 16, 2009 03:43AM
2049
June 16, 2009 10:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.