如何在mysql中插入\ N和tab字符串？

Question

I want to add a string that contain \N and a tab in the starting, i want to add this string into mysql database. And also want to fetch the same string using php. I did imported that type of string using csv file, but problem arises when i try to fetch that string.

Exmaple string : "\N Ada"

Mysql query :

$sql = "select `COL 1`, `COL 2` from `".$db_table."` where `".$db_column." like '\N\t".$keyword."%'";

$Keyword is the string with \N and a tab

Answer 1

Problem resolved by concatenating the \N and tab to the variable. Earlier i was concatenating this string in the query itself. Still don't know the root cause, but concatenating that string to the variable seem to fix the problem.