PHP将一串逗号分隔值转换为另一种格式，而不使用循环

Question

In php, if I had a string of comma separated data like this which came from a database:

John,Paul,Ringo,George

how could I convert it to something like this, without using a for loop or any extra processing. Does php have a function that can do this?

$str = 'John','Paul','Ringo','George';

I currently split the string using explode and then reformat it. Anyway to achieve this without doing that?

The formatted string is sent to a SQL where it's used in a MySQL IN() function.

Answer 1

If you absolutely don't want to use explode() you could use

$str = 'John,Paul,Ringo,George';
$newStr = "'" . str_replace(",","','", $str) . "'";