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
- 11927 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between delete and truncate commands?
What does the sign mean in sql?
Explain architecture of sql server notification services?
What are the different set operators available in sql?
What is user in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
How do I count duplicates in sql?
Define commit, rollback and savepoint?
how to calculate the difference between two dates? : Sql dba
What is the usage of when clause in trigger?
How to disable a trigger name update_salary?
what is a constraint? : Sql dba
What are the basic sql commands?
What does trigger mean in slang?
How do you write an inner join query?
