如何在mysql查询中搜索'\' [英] how to search for ' \ ' in like mysql query
问题描述
亲爱的朋友,
我在讨论项目时遇到了一些问题。当我试图通过使用类似查询在路径表中查找或搜索世界时,我得到了答案,但当我尝试找到世界之间的任何世界,例如在路径id = 1世界\ TOOLBAR \然后用\然后不给我答案。我想找到搜索世界在这个世界之间的路径表中,例如\ TOOLBAR \,\ APPPLICATION \,\ EPSON \ 在这种类型的世界中,给我一条完整的道路。 />
感谢高级!!
PathId路径
Dear Friend,
I have some problem when implimenting query for my project.When i am trying to find or search world in my path table by using like query i got answer but when i am trying to find any world just like in between world for example in path id =1 world is "\TOOLBAR\" then with "\" then not give me answer.I want to find search world in this path table between world for example "\TOOLBAR\","\APPLICATION\",\EPSON\ in this type of world and give me my full path.
Thanks in Advanced !!
PathId Path
1. '$PROGDIR$\SPEEDBIT VIDEO DOWNLOADER\TOOLBAR\GRABBER.DLL'
2. '$PROGDIR$\GOOGLE\CHROME FRAME\APPLICATION\11.0.696.71\NPCHROME_FRAME.DLL'
3. '$PROGDIR$\BUSINESS OBJECTS\BUSINESSOBJECTS ENTERPRISE 11.5\WIN32_X86\LIBXML2.DLL'
4. '$PROGDIR$\COMMON FILES\EPSON\EBAPI\EEBNWDEV.DLL'
5. '$WINDIR$\ASSEMBLY\NATIVEIMAGES_V2.0.50727_32\ACCESSIBILITY
\C2AF7CFBB47C077029A2645930B4EEAC\ACCESSIBILITY.NI.DLL'
6. '$PROGDIR$\MICROSOFT SQL SERVER\90\SETUP BOOTSTRAP\RESOURCES\1033\SQLSPARS.RLL'
7. '*:\UNISTAL\UBSUITE\COMMON FILES\SCHEDULAR.EXE'
8. '$USERPROFILE$\APPDATA\LOCAL\CYBERDEFENDER INTERNET SECURITY\ANTISPYWARE\EBLOCSAUTHENTIUM.DLL'
9. '$WINDIR$\ASSEMBLY\GAC_MSIL\CLI.ASPECT.MMVIDEO.GRAPHICS.DASHBOARD\2.0.3198.30422__90BA9C70F846762E\CLI.ASPECT.MMVIDEO.GRAPHICS.DASHBOARD.DLL'
推荐答案
PROGDIR
\ SPEEDBIT VIDEO DOWNLOADER \ TOOLBAR \GRABBER.DLL'
2.'
\SPEEDBIT VIDEO DOWNLOADER\TOOLBAR\GRABBER.DLL' 2. '
PROGDIR
这篇关于如何在mysql查询中搜索'\'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!