Write a stored procedure and in that stored procedure write 3 query as below
query1 = SELECT * FROM tableName WHERE cloumnName like RegExpForExactMatch;
query2 = SELECT * FROM tableName WHERE cloumnName like RegExpForAllMatch;
query3 = SELECT * FROM tableName WHERE cloumnName like RegExpForAnyMatch;
And then execute the query with the union;
Hope this will help you.