Searching records where the email column contains the keyword 'bates'

SELECT * FROM users WHERE email LIKE '%bates%'

In total, num of retrieved rows is 1:

5 Norman Bates normanbates@example.com 2024-10-20 19:16:41


That is the end of the query.