select substr(mail_id,instr(mail_id,'@',1)) from table

mail-id table contains two columns(email_id,userid)
it contains different types of mail-ids,and no of users.
here username length is differ na,(ex-
tamil@yahoo.com,joshua@hotmail.com like)
now i want to fetch the email-ids only starting from '@'
(ex-@gmail.com,@yahoo.com,@hotmail.com

Question Posted / raji_4u

5 Answers
11931 Views
I also Faced
E-Mail Answers

Answer Posted / raji_4u

select substr(mail_id,instr(mail_id,'@',1)) from table_name

This works fine.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we implement rollback or commit statement in a trigger?

1017

Which normal form is best?

937

explain mysql aggregate functions. : Sql dba

972

How do I run a sql query?

1001

What does the argument [or replace] do?

1064

Is sql open source?

954

Does sql backup shrink transaction log?

954

Is sql better than access?

995

Can you have a foreign key without a primary key?

938

What is the usage of nvl function?

1025

what are date and time functions in mysql? : Sql dba

964

What are the different sql languages?

1023

What is varchar used for?

1069

Explain the structure of pl/sql in brief.

1068

What is error ora-01000: maximum open cursors exceeded

1126