Is it possible to avoid the special meaning on '\' [backslash] in a MySql Query
Posted on 2002-07-03
I have a big problem!
I am storing the [windows] path of a file in a MySql
When I am Searching for a particular path
Select FILENAME from MyTable
[BUT \ has a special meaning to mysql] so
I have to give Path='C:\\WINDOWS\\DESKTOP\\myfile.txt';
Is it Possible to avoid the specail meaning of '\' in
a MySql Query.This is creating a lot of problems.....
For Example I have a Field EngLish Title which has a value
I Cannot directly search for the string 'MANAGER/DIRECTOR'.
I have to convert / TO // ..............
I there any way to avoid this .....