[AndrewSimm]

Originally Posted by kh99

You could try something like this:

SELECT title, CONCAT( 'http://www.website.com/dir/entry.php?e=', entryid ) AS link
FROM adv_dyna_entries
INTO OUTFILE 'out.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'

But you need to change 'out.csv' to a path where you can write a file on the server.

Thank, this is working for me now. I can only write it to my tmp dir in root which isn't a big deal unless that dir gets purged. Next I need to put this into a cron job that removes the file and then runs the query you give me. I think I can handle that.

You saved me a lot of time, thank you.