fenway

The export is mysql... the rest is php.

You can use SELECT ... INTO OUTFILE.

SUBSTRING(post FROM LOCATE('http://',post) FOR LOCATE(' ',post,LOCATE('http://',post))-1) AS url

You should be able to search for the first whitespace.

Sure... join the table with a left join using user_id in the on clause, then use IFNULL() for each field.

Unless your collation is case-sensitive (not the default), this won't do anything at all.

1) LENGTH(yourField) = 5 2) UPPER(lastName), LOWER(firstName) 3) I don't know your table structure 4) UPPER(LEFT(address,1))

What's in "post"? The whole things?

No one will ever have a second e-mail? If so, one table it is.

I don't understand your idea.

This "date arithmetic" functionality was added in v3.23 -- I seriously hope no one is using anything prior to that release (or that release, for that matter). So it's quite safe to use; and IMHO much easier to read without extra parens.

In fact, this is only way.

As long as no user will ever have 2 emails/passwords, you're right... but I would question the fromer.

Export a table into what?

First line/

Database of what?

Why LOWER()? That's bad for index usage!

What I mean what that there were "incomptable changes" between versions, so it could have affected your data and your queries!

We'll need more details...

Various flavours of TEXT come to mind...

Don't even consider *not* storing the ID.

It's called a derived table... just write the query and wrap it in parents, and put it in place of where you would put the table name.

Can we some some relevant code snippets?

And you've already read the sticky on this topic?

There an $optionl there... echo the query strying.