Could you tell me the account ids of those accounts too?
SELECT Account_ID FROM Accounts WHERE Account_details LIKE "%9%"
account ids of those accounts refers to Account_ID; accounts that contain the character '9' in their details refers to Account_details LIKE '%9%';