CODE EXAMPLE FOR SQL

mysql count newlines in field

select LENGTH(my_column)-LENGTH(REPLACE(my_column, '
', '')) as total_new_lines