select profilename from PROFILE where user_data like '%DATE_RULE!115%';

Output will be "Test A"
Now, this is just a single value from RULES table used to find the data of PROFILE table.
I will have to run the query on multiple values of RULES tables to find records containing a string format of sort "DATE_RULE!<rule_no>".
Does anyone have any suggestion to search on WILD CARDs like these?