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
12163 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

what is clause? : Sql dba

1116

How is a process of pl/sql compiled?

1234

explain what is mysql? : Sql dba

1128

What are different types of functions in sql?

1050

Explain the advantages and disadvantages of stored procedure?

1198

What are field types?

1051

Explain what is rdbms?

1085

What is an implicit commit?

1100

What is pl/sql table? Why is it used?

1089

What is a string data type in sql?

1100

What is difference between stored procedures and application procedures?

1061

Explain the uses of database trigger.

1175

Is sql dba a good career? : SQL DBA

1045

how can we know the number of days between two given dates using mysql? : Sql dba

1082

How can we find duplicate records in a table?

988