select column_x from tbl_xyz where column_y = 'abc def ghi'
new line characters i.e. '\n' in column_y should be replaced with a space character i.e. ' ' in this query. Is there any replace function that when used in the query with colulmn_y would do it?