Re: Perform UPDATE on rows from a SELECT

[Rick Macdonald]

Thanks, Peter, that works! No wonder I couldn't find an example of a WHERE clause with SELECT in it. DOH!

If I may, the other thing I can't find is how to format the output of SELECT to join two text fields without any delimiter. The two fields are a file path (ending with a "/") and a file name. I simply want to join them together. I can set it to a single space as shown below but specifying '' writes out gigabytes of blank lines.

SELECT strPath, strFileName FROM `episode_view` WHERE playCount IS NULL INTO OUTFILE '/tmp/t3' FIELDS TERMINATED BY " "