Convert an array into format for an WHERE IN mysql clause

Question

I have an array that contains strings

e.g array('14183f6c-9bf5', '074306fb-6eaf')

I want to convert this into a format readable for an mysql query with an IN statement but I keep getting issues as its a string..

Essentially get this to be formatted as such in my sql query - I am using implode but to no avail.. any ideas

Guid IN ("14183f6c-9bf5", "074306fb-6eaf")

$Guids = array('14183f6c-9bf5', '074306fb-6eaf');
$csv = implode('",', $Guids);

" I am using implode but to no avail.. any ideas" Show us the code. — Digital Chris, Jan 21 '15 at 15:07
$Guids = array('14183f6c-9bf5', '074306fb-6eaf'); $csv = implode('",', $Guids); — Zabs, Jan 21 '15 at 15:09
http://stackoverflow.com/questions/907806/php-mysql-using-an-array-in-where-clause?rq=1 — WeCanBeFriends, Aug 14 '15 at 17:44

krzysiej · Accepted Answer · 2015-01-21T15:18:25.977

6

try something like this

$whereIn = implode('","', $array); $sql = 'SELECT * FROM table WHERE col IN ("'.$whereIn.'")';

edited Jan 21 '15 at 15:18

answered Jan 21 '15 at 15:09

krzysiej

score 2 · Answer 2 · answered Jan 21 '15 at 15:18

2

try with this :

$whereIn = '("' . implode('","', $array) . '")';

answered Jan 21 '15 at 15:18

Halayem Anis

2 Answers2