read words are !=,<>,and ,or

I have string like this
SELECT # Ticket Updates WHERE Text Field= Assignee Name AND Ticket Status <> Deleted item

I want to read words after = or <>
Output must be
Assignee Name
Deleted item

wordAfter = SubstringExtensions.GetWordAfter(value.TrimEnd(), str.TrimEnd());

public static string GetWordAfter(string word,string phrase)
var pattern = @"\b" + Regex.Escape(word) + @"\s+(\w+)";

        return Regex.Match(phrase, pattern, RegexOptions.IgnoreCase).Groups[1].Value;

        //var pattern = @"(?:^|\b|\s)" + Regex.Escape(word) + @"\s*((?:\w+)|<>)";
        //return Regex.Matches(phrase, pattern, RegexOptions.IgnoreCase).ToString();

Try something like Microsoft.SqlServer.Management.SqlParser.Parser

.NET Foundation Website | Blog | Projects | Code of Conduct