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
12002 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 an invalid partition table?

1025

Does sql backup shrink transaction log?

983

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1230

What is an implicit commit?

1058

Which constraints we can use while creating database in sql?

1086

What is a full join sql?

1059

Compare sql & pl/sql

1143

What does count (*) mean?

936

Which table is left in left join?

1017

What is the purpose of my sql?

953

What is an oracle stored procedure?

1054

What is materialized view in sql?

924

explain access control lists. : Sql dba

1003

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4015

What is 19 null in sql?

972