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
- 12159 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 faster join or subquery?
Write a sql query to find the names of employees that begin with ‘a’?
What is a boolean in sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Is primary key a clustered index?
What are properties of the transaction?
what are different types of keys in sql?
What port does sql server use?
What is type and rowtype in pl sql?
How do you get column names only for a table (sql server)?
What are the types of variable use in pl sql?
Is pl sql still used?
What are different functions in sql?
Which normal form is best?
