mysql count new lines code example

Example: mysql count newlines in field

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