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
- 11060 Views
- I also Faced
- E-Mail Answers
Answer Posted / rk
select substr(mail_id,1,instr(mail_id,'@')-1) from
test_rk_mail
Regards,
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the advantages of sql?
What are database links used for?
What is cost in sql execution plan?
how to escape special characters in sql statements? : Sql dba
What pl/sql package consists of?
Give the order of sql select?
I need a function for a train ticket reservation please answer it thanks in advance
How do you delete duplicates in sql query using rowid?
Why are sql stored procedures used?
What is a parameter query?
How do I delete a trigger?
What found sql?
How to check if a column is nullable before setting to nullable?
What is the difference between in and between in sql?
how do you login to mysql using unix shell? : Sql dba
