You have missed out the field name
id in the second
NOT LIKE. Try:
SELECT * FROM transactions WHERE id NOT LIKE '1%' AND id NOT LIKE '2%'
AND in the where clause joins 2 full condition expressions such as
id NOT LIKE '1%' and can’t be used to list multiple values that the id is ‘not like’.