can i do this?

[Anon]

i have a table(tbl1) that has a column containing email addresses which are
in the format mailto:[e-mail]?subject= blah.

This table isnt related to any other tables in my database. I would like to
be able to relate it by creating another column that contains only the email
part of the address eg [e-mail] (notice the absence of the mailto:
and subject?= blah).

One of my tables (tbl2)has a column containing email addresses in the
[e-mail] .

I am thinking that if i can find a way of updating tb1 so that it contains
duplicate info similar to that of tbl2 that i could then relate the tables
and use them in my queries.

I have looked through the php manual and thought that i might be able to use
strstr()

eg $email = 'mailto:[e-mail]?subject= blah';
$domain = strstr($email, ':');
print $domain; // prints :[e-mail]?subject= blah

I have three problems with this

1. it doesnt really serve my purpose because the : would be at the front of
   every address as would be the ?subject= blah

2 this php approach seems almost like overkill in that there should be an
easier sql or combined alternative

3.I know that concat works in sql queries. Is there a deconcat function that
I could use
eg deconcat $string

a simplified verison of what i need is something along the lines of

update tb1 set column2 = deconcat('mailto:',column1,'?subject= blah')

hope you people understand what i mean please ask if you need any
clarification

R

[Anon]

What you want is the preg_split function. Try your hand at writing a regular expression; it's really an awesome tool, but not the simplest concept to master...

[Anon]

thanks ill check it out

[Anon]

just thought id share this

courtesy of a chap named ewgenij

$query = mysql_query( "select email from email_count" );
while( $row = mysql_fetch_array( $query ) )
mysql_query( "update email_count set emailadd = '" . substr( strchr(
$row["email"], ":" ), 1, strpos( strchr( $row["email"], ":" ), "?"
) - 1 ) . "' where email = '" . $row[ "email" ] . "'" );