如何在foreach Array中运行此SQL以获取唯一的Query

Question

I have an Array,

$array = array("rating_battery", "rating_display", "rating_design");

Array output;

Array
(
    [0] => rating_battery
    [1] => rating_display
    [2] => rating_design
)

I have SQL Query,

$query = "SELECT ID, meta_value, meta_key
FROM table_name
WHERE meta_key = $value"

I use foreach;

foreach ( $array as $value ) {
    $query = "SELECT ID, meta_value, meta_key
    FROM table_name
    WHERE meta_key = $value"
}

How to get unique $query like this with foreach.

1. $query_rating_battery with meta_key = 'rating_battery'
2. $query_rating_display with meta_key = 'rating_display'
3. $query_rating_design with meta_key = 'rating_design'

Please help, thanks.

Answer 1

I think you can just use WHERE IN:

SELECT ID, meta_value, meta_key
FROM table_name
WHERE meta_key IN implode(',', $value)