I'm having trouble trying to export a csv file from a Joomla database which contains some HTML. I can see the data laid out perfectly in PHPMyAdmin when I carry out an SQL command like this:
SELECT `id` , `title` , `alias` , `introtext` , `fulltext`
However, when I try to export the data as a csv file, everything goes a bit awry (I'm assuming it's because there's a delimiter in the introtext or fulltext HTML). When I try to open the file in Numbers (Mac equivalent of Excel), there are multiple rows i.e. it's not in the same tabble format as in PHPMyAdmin.
The settings I'm using in PHPMyAdmin to export the data are:
Export : CSV
Fields terminated by : ,
Fields enclosed by : "
Fields escaped by : \
Lines terminated by : AUTO
Replace NULL by : NULL
Does anyone know what I can try as I'm new to this?
Anyone got any ideas? Sorry for urgency, but I need to do this asap.