Search on mysql , the ":" is reserved word ?

Question

1.00/5 (1 vote)

See more:

field Test type Varchar(100)

value on path "D:\\Test"

<pre>value on path "D:"

is just in character :

I solve like this
Drive varchar(1)
Path varchar(100)

d
Test

SELECT * FROM db_catalogo.tb_import
WHERE db_catalogo.tb_import.drive = 'D'
AND db_catalogo.tb_import.path = 'Test';

but to be able to use the full path (D:\Test) would be more comfortable

What I have tried:

Query with MySqlWorkBench

SELECT * FROM db_catalogo.tb_import
WHERE db_catalogo.tb_import.path LIKE 'd%';
ok , find record

SELECT * FROM db_catalogo.tb_import
WHERE db_catalogo.tb_import.path LIKE 'd:%';
no record found

Posted 9-Apr-21 5:59am

Member 13174280

Updated 12-Apr-21 4:11am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

diginet0 · Answer 1 · 2021-04-12T04:11:00

The issue comes because \x is interpreted as an escape character. One way to avoid this is change the \ by / in all path. If You don't want to do that you can use \\ what means \ itself for each \ in the text You are looking for. For instance:

If You stored 'D:\Test' in the column db_catalogo_tb_import.path the the select command should be like:

SQL

select * from db_catalogo.tb_import where db_catalogo.tb_import.path='D:\\Test';

If You stored 'D:\\Test' then the select command should be like:

SQL

select * from db_catalogo.tb_import where db_catalogo.tb_import.path='D:\\\\Test';