Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 12010 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
What is pl sql quora?
What is sql architecture?
What is the purpose of normalization?
Why use truncate instead of delete?
what is a unique key ? : Sql dba
What does select * from mean in sql?
What is the use of sqlerrd 3?
What is right join sql?
What is the difference between explicit and implicit cursors in oracle?
How to select 10 records from a table?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What are the advantages of pl sql over sql?
Can we write ddl statements in functions?
Can we insert in view in sql?
Is sql difficult?
