using System;
using System.Text.RegularExpressions;
 
class Program
{
  static void Main()
  {
    string input = "select ceiling(a.interest) as interest, a.myID as mID, a.studentID as sID from mytable";
    string column = "a.myID";
    string pattern = "((?<=\\bselect)\\s+[^,]*\\b" + Regex.Escape(column) + "\\b[^,]*\\s*,?|\\s*,\\s*[^,]*\\b" + Regex.Escape(column) + "\\b[^,]*(?=(?:,|\\sfrom\\b)))";
    string output = Regex.Replace(input, pattern, "", RegexOptions.IgnoreCase);
    Console.WriteLine(output);
  }
}

dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uVGV4dC5SZWd1bGFyRXhwcmVzc2lvbnM7CiAKY2xhc3MgUHJvZ3JhbQp7CiAgc3RhdGljIHZvaWQgTWFpbigpCiAgewogICAgc3RyaW5nIGlucHV0ID0gInNlbGVjdCBjZWlsaW5nKGEuaW50ZXJlc3QpIGFzIGludGVyZXN0LCBhLm15SUQgYXMgbUlELCBhLnN0dWRlbnRJRCBhcyBzSUQgZnJvbSBteXRhYmxlIjsKICAgIHN0cmluZyBjb2x1bW4gPSAiYS5teUlEIjsKICAgIHN0cmluZyBwYXR0ZXJuID0gIigoPzw9XFxic2VsZWN0KVxccytbXixdKlxcYiIgKyBSZWdleC5Fc2NhcGUoY29sdW1uKSArICJcXGJbXixdKlxccyosP3xcXHMqLFxccypbXixdKlxcYiIgKyBSZWdleC5Fc2NhcGUoY29sdW1uKSArICJcXGJbXixdKig/PSg/Oix8XFxzZnJvbVxcYikpKSI7CiAgICBzdHJpbmcgb3V0cHV0ID0gUmVnZXguUmVwbGFjZShpbnB1dCwgcGF0dGVybiwgIiIsIFJlZ2V4T3B0aW9ucy5JZ25vcmVDYXNlKTsKICAgIENvbnNvbGUuV3JpdGVMaW5lKG91dHB1dCk7CiAgfQp9