MySQL Forums
Forum List  »  General

select certain character in the column
Posted by: Yi Ling
Date: November 01, 2004 08:25PM

i have 3 columns in the tables --> Company, name, email

if i want to retrieve the domain name of the company.......

e.g. company name email
Ang Mo Kio abc abc@angmokio.com
Ang Mo Kio xyz xyz@angmokio.com
Ang Mo Kio who who@angmokio.com.sg

how can i check for the email.. and just retrieve the word after '@' (domain name) ???

any help is muchly appreciated...

Options: ReplyQuote


Subject
Written By
Posted
select certain character in the column
November 01, 2004 08:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.