making mysql query using splite string?
- by Marco
lets say i have a group of number like (3,2,5) the normal way i use to split them and searching mysql to get value is to split them using explode in PHP
EXAMPLE
$string = '3,4,5';
$array = explode(',',$string);
foreach($array as $value){
$query = 'SELECT ID FROM TABLE WHERE ID = "'.$value.'"';
}
it work like this but it make the script extremely slow
i need now if there is away to split this string into the query it self and return the result without looping with PHP ?
