Warm tip: This article is reproduced from stackoverflow.com, please click
oracle sql

In oracle how to retrieve users who has @gmail extension mails from email column from user table

发布于 2020-03-27 15:45:53

I need the oracle query to retrieve users who has @gmail extension mails from email column from users table.

Questioner
SuNnY
Viewed
88
Atk 2020-01-31 13:18
select * from users where email like '%@gmail%'