mysql trim new line select query

mysql trim new line select query

select * from tablename where TRIM(BOTH '\r' from (TRIM(BOTH '\n' from filedname))) = '$value' 

Here the for new line and for Carriage Return to trim in the field value before condition prove.