MySQL Forums
Forum List  »  Newbie

Re: Fetching multiple values with single select
Posted by: Eran Yasso
Date: July 19, 2018 06:31AM

Hi Phill,

1. I explain. I have following ids (1, 343, 20934 and 189).
FOr each one of them I need to get imageUrl and productName.
This means that I need to have 4 different select.
select call for each of the ideas. This is fine if i have 4 ids. However, if I have 1000 ids, I need to make 1000 select calls (select call per id). What I am asking if there is other way to do that. maybe using some kind of array which holds all the ids?

2. My second question is for saving object. Is it good approach to save object by serializing it to json and saving it as string or there is other type which I can do it?

Thanks,

Options: ReplyQuote


Subject
Written By
Posted
Re: Fetching multiple values with single select
July 19, 2018 06:31AM


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.