select substr(mail_id,instr(email_id,'@'),(length (email

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 / amitabha mandal

5 Answers
11782 Views
I also Faced
E-Mail Answers

Answer Posted / amitabha mandal

select substr(mail_id,instr(email_id,'@'),(length
(email_id,'@') - instr(email_id,'@'))+1) from table_name.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I install sql?

943

What is a sql statement?

903

How do you write a subquery?

968

Explain what is table in a database?

1008

what is the difference between a web-garden and a web-farm? : Sql dba

1012

How to create your own reports in sql developer?

976

What is sql partition function?

1120

How do you optimize a query?

941

What is a .db file?

928

what are local and global variables and their differences? : Sql dba

1010

What is foreign key sql?

947

Enlist the advantages of sql.

939

What is where clause in sql?

984

What is the best free sql database?

1001

explain what is mysql? : Sql dba

1032