Hopefully someone can help me with a quick answer.
I have a transaction table with a 'description' column that contains a combination of the members name and some static information i.e. "'username' PURCHASE" or "'username' PAYMENT"
and a 'type' column that contains various types of transactions i.e. 'FEE' or 'EARN'
I have a list of usernames, and I need to get the transaction number from each of these records where the 'description' contains a username from the list and the 'type' ='FEE'.
I don't know how to use the LIKE with the % wildcard along with the IN (using a list)
Any help would be greatly appreciated.