Shulou(Shulou.com)05/31 Report--

This article mainly introduces sql how to query the in in the array, the article is very detailed, has a certain reference value, interested friends must read it!

$platform_ministry = M ('platform_ministry')-> where (array (' platform_id'= > $platform_id))-> select (); / / all departments id / / array_column () function fetches the specified column array_column (recordset, field name) $ministry_ids = array_column ($platform_ministry,'ministry_id') from the recordset $ministry = M ("ministry")-> where (array ('section_id'= > array (' in',$ministry_ids), 'is_del'= > 1))-> limit (13)-> select (); Table name-> where (' field name'= > array ('in', recordset),' field name'= > value)-> number of entries-> select ()

If you look at it carefully, you can understand it, and if you change it, you can use it.

These are all the contents of the article "how to query in in an array by sql". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.