How to select records in sql, knowing their id?

Question

MySQL

I have a table that stores links to favorite articles by users. To select the id of all the posts that the user has marked as favorite, you need to apply this code:

SELECT `targetid` FROM `chosenlink` WHERE `type`=1 AND `userid`=".$userinfo['id']

type is the record type; 1 - article; 2 - question and so on.
And so we have id of all articles which the user added to favorites.
how can I further identify all the articles with the id that we received with the code above (it is clear that mysqli_fetch_array comes after this)

Answer 1

The question is a little not clear
So far, we can say for sure that the search is done like this. You just have to substitute your set of ids
select * from table where id in (1, 2, 3, 4 ....)

Answer 2

If, of course, I correctly understood the question, then you need JOIN , something like this:

SELECT `t2`.*  FROM `chosenlink` `t1` JOIN `table` `t2` ON `t1'.`targetid` = `t2`.`id` WHERE `type`=1 AND `userid`=".$userinfo['id']