Path Problems in mysql Query fields

Path problem in the mysql Query field my mysql is ubuntu 5.5, and a table is the windows path for saving files, such as e: \ test. in the result, select & nbsp; * & nbsp; from & nbsp; table name & nbsp; where & nbsp; file _ path problem in mysql Query field
My mysql is ubuntu 5.5,
A table is a windows path for saving files, such as e: \ test. in the result, select * from table name where file_path like "% e: the \ test % "statement cannot query any records. only the select * from table name where file_path like" % \ test % "can be entered to query records.
------ Solution --------------------
When storing e: \ test, convert it to e first.
------ Solution --------------------
Test is stored again.
------ Solution --------------------
Replace :\
------ Solution --------------------
E: \ test?
------ Solution --------------------
It seems that escape of character sequences is involved.