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
- 12166 Views
- I also Faced
- E-Mail Answers
Answer Posted / raji_4u
select substr(mail_id,instr(mail_id,'@',1)) from table_name
This works fine.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to get each name only once from an employee table?
describe transaction-safe table types in mysql : sql dba
What is the difference between instead of trigger and after trigger?
How do you clear the screen in sql?
How do I view a sql database?
What is clause in sql?
List different type of expressions with the example.
How many sectors are in a partition?
What is the difference between the implicit and explicit cursors?
What is execute immediate?
Can we use pl sql in sql server?
What language is oracle sql developer?
how to create a test table in your mysql server? : Sql dba
What is replication id?
what are the different tables present in mysql? : Sql dba
