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
- 11072 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
Why do we use subquery?
Explain the uses of a database trigger?
What does the argument [or replace] do?
Can I learn sql in a week?
what is 'mysqlimport'? : Sql dba
What are the two types of periodical indexes?
Is left join faster than inner join?
How can I get the number of records affected by a stored procedure?
How do I enable sql encryption?
What is the unique index?
Which command is used to call a stored procedure?
What is embedded sql with example?
How much does sql certification cost?
How to move files from one directory to another in pl sql?
What are the parts of a basic sql query?
