This problem asks for a SQL query to find all users in a table who have a valid email address.
Given a table of user data, write a SQL query to find all users who have a valid email address. Input: User table with columns: id, name, email Output: List of all users with a valid email address
SELECT * FROM User WHERE email LIKE '%@%' /* The above solution is optimal because it uses the LIKE operator to check if the email contains an @ symbol. */
The solution correctly uses the LIKE operator to check if the email contains an @ symbol.
Evaluated at: 2022-10-31 02:36:00