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

What is prepared statement in sql?

993

Why are sql stored procedures used?

987

Is drop table faster than truncate?

940

What are sql injection vulnerabilities?

909

how to get @@error and @@rowcount at the same time? : Sql dba

968

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

969

Is nosql relational?

893

Which sql statement is used to return only different values?

953

When is the explicit cursor used ?

977

Is record in pl sql?

915

What is pl sql in dbms?

900

How does sql developer connect to oracle database?

949

what are date and time data types in mysql? : Sql dba

917

What is trigger in sql?

1027

What is a string data type in sql?

957