$stmt = $db->prepare(
'SELECT *
FROM `table`
WHERE FIND_IN_SET(`id`, :an_array)'
);
$stmt->execute(['an_array' => implode(',', $ids)]);
Regex regex = new Regex(@"G0(\d)");
TextBox1.Text = regex.Replace(textBox1.Text, "G$1");
Regex regex = new Regex(@"\.");
TextBox1.Text = regex.Replace(textBox1.Text, ",");
Regex regex = new Regex(@"^([XY])", RegexOptions.Multiline);
TextBox1.Text = regex.Replace(textBox1.Text, "G5 $1");
Regex regex = new Regex(@"([XYZIJ])");
TextBox1.Text = regex.Replace(textBox1.Text, " $1");
https://jsfiddle.net/hhy2apmp/10/