逃避sqlite通配符 [英] escaping sqlite wildcards

问题描述

我正在尝试搜索此字符串

am trying to perform a search for this string

! @ # $ % ^ & * ( ) '

然后我使用sql语法

then i used the sql syntax

Select ID From Tasks Where task LIKE '[!] [@] [#] [$] [%] [^] [&] [*] [(] [)] ''%'

但我没有得到任何结果，任何帮助

but i dont get any result, any help

推荐答案

％^& *（）'

% ^ & * ( ) '

然后我使用sql语法

then i used the sql syntax

Select ID From Tasks Where task LIKE '[!] [@] [#]

[ ％] [^] [&] [*] [（] []]''％'

[%] [^] [&] [*] [(] [)] ''%'

但我没有得到任何结果，任何帮助

but i dont get any result, any help

可能你想要：

Probably you want:

SELECT ID FROM Tasks WHERE task LIKE '! @ #

这篇关于逃避sqlite通配符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！