I have an array of dates, how do I use each one in a mysql query?

Question

I have a array of dates. For each date, I want to insert it into the where clause of a query, then store the resulting value (a count of something) into a new table.

This similar question provides an answer in php, but I need to do this strictly in mysql. Thanks in advance for your help.

EDIT: by array, I just mean a list of things. For instance, a table with one row of date values. Thanks.

Does this answer your question? [mysqli bind\_param for array of strings](https://stackoverflow.com/questions/17226762/mysqli-bind-param-for-array-of-strings) — mickmackusa, Apr 03 '22 at 21:07
and https://stackoverflow.com/questions/3703180/use-an-array-in-a-mysqli-prepared-statement-where-in-query — mickmackusa, Apr 03 '22 at 21:07

score 0 · Answer 1 · answered Jun 14 '13 at 00:53

0

iterate the array and build your where clause?

something like:

$where = "WHERE";
foreach($date as $dates){
$where .= " AND " . $date . = " some column";
}

answered Jun 14 '13 at 00:53

Stefano L

1,486
2
15
36

I have an array of dates, how do I use each one in a mysql query?

1 Answers1