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
- 11980 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
How do you write a subquery?
What is the default isolation level in sql server? : Transact sql
How is a PL/SQL code compiled?
Does mysql support pl sql?
How do I restart sql?
What is case function?
What is record in pl sql?
Why do we use function in pl sql?
Can primary key be changed?
How do you explain an index?
What is package in pl sql with an examples?
Why do we use procedures in sql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How can I see all tables in sql?
What is the difference between inner join and outer join?
