Truncating portion of e-mail address

[Anon]

I am running a query for a MySQL database to pull in the values of the field user_email.

How would the syntax of a query look to remove the portion of the e-mail addresses after the @ symbol?

e.g I want [e-mail] to read
either johndoe@ or johndoe@** so it will be obvious that it was intentionally truncated.

Thanks.

[Anon]

You can just explode [e-mail]

$email = explode("@", $user_email);

You now have two parts in an array:

$email[0] will be johndoe,
$email[1] will be aol.com.

Finally, add @ to $email[0].

$email = $email[0] . "@";

Richie.
geocities.com/akindele/

[Anon]

Thanks Richie...very helpful indeed.

[Anon]

Is there a MySQL query command that would do similarly?

e.g.

user_email

[e-mail]
[e-mail]
.
.
.
[e-mail]

Select user_email as email_short FROM dbase yada yada yada

[Anon]

okay...i found the answer:

SELECT SUBSTRING_INDEX(user_email, '@', 1) as email_short