Search in by email?

M

Maxim2016-07-15 16:47:12

PostgreSQL

Maxim, 2016-07-15 16:47:12

Search in by email?

Hello.
The database has an email column.
I need to pull out in the request not the full email of the user, but only what is from @ to the first dot.
Can you please tell me how to make this condition in the request?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Andrey Burov, 2016-07-15
@BuriK666

https://www.postgresql.org/docs/current/static/fun...

Similar questions

M

malkovan2019-11-16 18:15:04

PostgreSQL query with filtering? 1Reply

N

neulwert2019-11-17 17:46:11

How to solve postgresql error: IMPORTANT: User not authenticated (by password)? 1Reply

M

Max2021-05-12 11:27:45

How to properly organize PostgreSQL database structure for different accounts? 2Reply

V

Vladimir2021-05-13 14:53:38

How to catch a request floating in time? 1Reply

S

shamyyl2015-07-14 11:05:32

Postgis vs Sphinx. What is better to use for searching by coordinates? 1Reply

Didn't find what you were looking for?

Ask your question