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
- 11981 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 is 'mysqlshow'? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
How do you modify a table in sql?
How does left join work in sql?
What is the usage of sql functions?
what is a constraint? Tell me about its various levels. : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba
What are the most important characteristics of pl/sql?
How do temporal tables work?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Which sql statement is used to delete data from a database?
What are its different types of dbms?
Does mysql support pl sql?
what is user defined functions? : Sql dba
Can sql developer connect to db2?
