Converting from MySQL

From: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
To: <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Converting from MySQL
Date: 2019-01-22 21:21:03
Message-ID: 000101d4b298$61f471d0$25dd5570$@1nar.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I am trying to install a mail server using PostgreSQL on a Debian 9 Stretch.
Document I am following is for MySQL. I converted other simple SQL commands.
Failed to find PostgreSQL equivalent for below one because I did not
understand what it does in the first place.

SELECT
CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
FROM users WHERE email='%s'

Any help is appreciated.

Thanks & regards,
Ertan Küçükoğlu

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2019-01-22 21:42:25 Re: Converting from MySQL
Previous Message Steve Midgley 2019-01-04 21:04:28 Re: How to create index on json array in postgres