My problematic code:

testMYSQL=`mysql -u $mysqlUser -p$mysqlPass -h $mysqlHost --skip-column-names --batch -D $mysqlDB -e "SELECT $select FROM $mysqlTable WHERE nameTXT='test';"`       

$testMYSQL now contains:

test
test
test

Then I do:

TEST=$(echo $testMYSQL | wc -l)
echo "$TEST"

I would of thought that would work, but it doesn't, it returns 1

But if I put this into $testMYSQL: "test\ntest\ntest" it will say 3…

Whats going on here? does MYSQL not use new lines?

PS, I know I can use a for loop to loop though the lines then count up the lines that way, but I was hoping for a simpler solution like wc