How to filter email in query?

I want to condition a query to return only valid email. Am I doing it correctly? How will this effect performance?

Reference

I’m not exactly sure what you you are trying to do here. From what you posted, your result will always be 0 records as %@%_% is expected as a string.

mail_status is boolean so that’s not an issue here. I want this query to return only valid email address. I’m trying to achieve as opposite to the answer from the stackoverflow.

Ok I’ve tested it. Works as expected. Cheers. :grin: