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
- 11778 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
How many types of triggers are there in pl sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
How do I order columns in sql?
What is partition in sql query?
Show how functions and procedures are called in a pl/sql block.
What is left join in sql?
How do sql triggers work?
What is use of trigger?
what is 'mysqlshow'? : Sql dba
Why should I use postgresql?
Does sql view stored data?
How much ram can sql express use?
What are %type and %rowtype for?
What is the difference between numeric and autonumber?
Is primary key always clustered index?
