MySQL SELECT WHERE php数组等价[关闭]

Question

I am wanting to know if there is such a thing like the MySQL SELECT WHERE but in arrays.

I have this array:

$array = array( 1 => array('test' => '1',   'test2' => '2'  ),
                 2 => array('test' => '4','test2' => '2'
               )

);

I am basically wanting all the records where 'test2' = '2'. So my result should be the id's 1,2.

Can this be done?

Answer 1

You're looking for array_filter:

array_filter($array, function ($v) { return $v["test2"] === "2"; });