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
- 11785 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raji_4u
select substr(mail_id,instr(mail_id,'@',1)) from table_name
This works fine.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / paul
just tel me is that wat u exactly want
table -Email
email_id user_id
joy@yahoo.com joySmith
waine@gmail.com WaineR
@gmail.com tr222
@yahoo.com huip
if m not wrong in understanding ur question that is u
required the 2 records with emailid as @gmail.com and
@yahoo.com
then u can use the sql statment -with like...
select * from email where email_id like '@%';
email_id user_id
@gmail.com tr222
@yahoo.com huip
hope m correct...
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / rk
select substr(mail_id,1,instr(mail_id,'@')-1) from
test_rk_mail
Regards,
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / mail2sentha
select email_id,user_id,substr(email_id,instr
(email_id,'@'),length(email_id)) from mail_id;
i think its correct?
| Is This Answer Correct ? | 1 Yes | 4 No |
When do we use triggers?
What do you know by pl/sql cursors?
Mention what does the hierarchical profiler does?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is procedure and function?
What are character functions in sql?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
Why schema is used in sql?
how to calculate the difference between two dates? : Sql dba
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
How to get each name only once from an employee table?
What is sql exception?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
