Select One Record?

nikko50

Hi guys🙂
I'm looking to query one record in each order where one item has been shipped. Most of the orders have about 100 items so I was wondering is there a quicker way to query just for one item in each order. I've been using the below to select all . It works but was wondering if there is a quicker way becuase I just need to find one item, marked SHIPPED. Thanks Tracy

SELECT * from orderDetails WHERE orderid='$line[orderid]'
AND orderDetails.itemstatus = 'SHIPPED'"

bogu

nikko50 wrote:
....quicker way to query.....
....
I just need to find one item, marked SHIPPED. Thanks Tracy

SELECT * from orderDetails WHERE orderid='$line[orderid]'
AND orderDetails.itemstatus = 'SHIPPED'"

Actually this is what u are doing, u are trying tu find one item (orderid='$line[orderid]') that is marked SHIPPED (itemstatus = 'SHIPPED'), how quicker then that u think u can make it?

Let me refraze, how quicker do u think it could be made? u are using one query and the exact condition u want; it cant be quicker ...

nikko50

I thought because there could be hundreds of 'SHIPPED' items per order rather than select all of them just find one???

bogu

Well if u have 100 of orderid='$line[orderid]' (ex. orderid=10) and like 50 itemstatus = 'SHIPPED', this select is colecting u all the 50 orderid that have itemstatus = 'SHIPPED'.

If u wnat to check only one item that have itemstatus SHIPPED, this means u know the item id and we will call it '$id', then u have to tell to mysql to show u the itemid='$id' that have itemstatus = 'SHIPPED', if is not showing u the item then that item is not SHIPPED.

bubblenut

Do you have the table indexed correctly? If not, and the speed of the query is causing issue then think about putting indexes on orderid and itemstatus.
Assuming you're using MySQL
About Indexing
Adding an index to an existing table