温馨提示:本文翻译自stackoverflow.com，查看原文请点击：sql - In oracle how to retrieve users who has @gmail extension mails from email column from user table

oracle sql

sql - 在oracle中如何从用户表的电子邮件列中检索具有@gmail扩展邮件的用户

发布于 2020-03-27 16:13:42

我需要oracle查询来从用户表的电子邮件列中检索具有@gmail扩展邮件的用户。

提问者

SuNnY

被浏览

103

查看英文版

查看原文

Atk 2020-01-31 13:18

select * from users where email like '%@gmail%'

相关问题

1

查询可能很慢？

2

简单的SQL角色查询问题

3

按汇总查询分组

4

如何在MySQL语句中包含PHP变量

5

从PostgreSQL中的“全选”查询获取空行

6

使用Java的MySQL枢纽分析表

7

通过数据库中的文本字段实现智能搜索

8

如何使用MySQL中的Between子句加快count（distinct）

9

如何执行sql查询MIN / MAX FILTER

10

Oracle SQL中的动态数据透视

热门github

1

"DeepCode: Open Agentic Coding (Paper2Code & Text2Web & Text2Backend)"

2

3

Clone a voice in 5 seconds to generate arbitrary speech in real-time (翻译：5秒克隆语音，实时生成任意语音)

4

Run LLMs with MLX

5

🚀🤖 Crawl4AI: Open-source LLM Friendly Web Crawler & Scraper. Don't be shy, join here: https://discord.gg/jP8KfhDhyN

6

Invoicing, Time tracking, File reconciliation, Storage, Financial Overview & your own Assistant made for Freelancers

7

A cryptocurrency trading API with more than 100 exchanges in JavaScript / TypeScript / Python / C# / PHP / Go (翻译：一个 JavaScript / Python / PHP 加密货币交易 API，支持 100 多个比特币/山寨币交易所)

8

all of the workflows of n8n i could find (also from the site itself)

9

AI coding agent, built for the terminal.

10

Perplexica is an AI-powered search engine. It is an Open source alternative to Perplexity AI

11

Parsing gigabytes of JSON per second : used by Facebook/Meta Velox, the Node.js runtime, ClickHouse, WatermelonDB, Apache Doris, Milvus, StarRocks

12

G-code generator for 3D printers (Bambu, Prusa, Voron, VzBot, RatRig, Creality, etc.)

13

An AI Hedge Fund Team

14

FULL v0, Cursor, Manus, Augment Code, Same.dev, Lovable, Devin, Replit Agent, Windsurf Agent, VSCode Agent, Dia Browser, Xcode, Trae AI, Cluely & Orchids.app (And other Open Sourced) System Prompts, Tools & AI Models.

15

PowerShell for every system! (翻译：适用于各系统的PowerShell)