blocks|key|779394|text|SQLite3支持REGEXP运算符：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|779395|WHERE+x+REGEXP+<regex>|code-block|syntax|javascript|779396|http://www.sqlite.org/lang_expr.html#regexp|offset|length|779397|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|17|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|T|8|@]|9|@$I|U|J|V|1|W]]|A|$]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|H]]]]

SQLite3 supports the REGEXP operator:

<pre><code>WHERE x REGEXP &lt;regex&gt;
</code></pre>

<a href="http://www.sqlite.org/lang_expr.html#regexp" rel="noreferrer">http://www.sqlite.org/lang_expr.html#regexp</a>

blocks|key|994000|text|正如其他人已经指出的，REGEXP调用用户定义的函数，该函数必须首先定义并加载到数据库中。也许一些sqlite发行版或GUI工具在默认情况下包含它，但我的Ubuntu安装没有。解决方案是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994001|sudo+apt-get+install+sqlite3-pcre|code-block|syntax|javascript|994002|，它在/usr/lib/sqlite3/pcre.so的可加载模块中实现Perl正则表达式。|offset|length|style|CODE|994003|为了能够使用它，您必须在每次打开数据库时加载它：|994004|.load+/usr/lib/sqlite3/pcre.so|994005|或者你可以把这一行放到你的~/.sqliterc里。|994006|现在您可以像这样查询：|994007|SELECT+fld+FROM+tbl+WHERE+fld+REGEXP+'\b3\b';|994008|如果想要直接从命令行查询，可以使用-cmd开关在执行以下操作之前装载库：|994009|sqlite3+"$filename"+-cmd+".load+/usr/lib/sqlite3/pcre.so"+"SELECT+fld+FROM+tbl+WHERE+fld+REGEXP+'\b3\b';"|994010|如果你使用的是Windows，我想应该有一个类似的.dll文件。|994011|entityMap^0|0|0|3|O|0|0|0|D|B|0|0|0|H|4|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@$I|17|J|18|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|19|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|1A|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|1B|8|@$I|1C|J|1D|K|L]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1E|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|1F|8|@]|9|@]|A|$E|F]]|$1|W|3|X|5|6|7|1G|8|@$I|1H|J|1I|K|L]]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1J|8|@]|9|@]|A|$E|F]]|$1|10|3|11|5|6|7|1K|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]]|13|$]]

As others pointed out already, REGEXP calls a user defined function which must first be defined and loaded into the the database. Maybe some sqlite distributions or GUI tools include it by default, but my Ubuntu install did not. The solution was

<pre><code>sudo apt-get install sqlite3-pcre
</code></pre>

which implements Perl regular expressions in a loadable module in <code>/usr/lib/sqlite3/pcre.so</code>

To be able to use it, you have to load it each time you open the database:

<pre><code>.load /usr/lib/sqlite3/pcre.so
</code></pre>

Or you could put that line into your <code>~/.sqliterc</code>.

Now you can query like this:

<pre><code>SELECT fld FROM tbl WHERE fld REGEXP '\b3\b';
</code></pre>

If you want to query directly from the command-line, you can use the <code>-cmd</code> switch to load the library before your SQL:

<pre><code>sqlite3 "$filename" -cmd ".load /usr/lib/sqlite3/pcre.so" "SELECT fld FROM tbl WHERE fld REGEXP '\b3\b';"
</code></pre>

If you are on Windows, I guess a similar .dll file should be available somewhere.

blocks|key|993855|text|在不使用正则表达式的情况下，一种简单的解决方法是where+','+%7C%7C+x+%7C%7C+','+like+'%25,3,%25'|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|993856|entityMap^0|O|Y|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

A hacky way to solve it without regex is <code>where ',' || x || ',' like '%,3,%'</code>

blocks|key|993923|text|默认情况下，SQLite不包含正则表达式功能。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|993924|它定义了一个REGEXP运算符，但除非您或您的框架define+a+user+function调用regexp()，否则此操作将失败并显示错误消息。如何做到这一点将取决于您的平台。|offset|length|style|CODE|993925|如果定义了regexp()函数，则可以匹配逗号分隔列表中的任意整数，如下所示：|993926|...+WHERE+your_column+REGEXP+"\b"+%7C%7C+your_integer+%7C%7C+"\b";|code-block|syntax|javascript|993927|但实际上，如果您使用逗号分隔的列表中每个数字的单独行替换这些groups+within+a+single+column，您会发现事情变得容易得多。然后，您不仅可以使用=运算符而不是正则表达式，还可以使用更强大的关系工具，如SQL为您提供的连接。|993928|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlite.org/c3ref/create_function.html|1|http://en.wikipedia.org/wiki/First_normal_form#Repeating_groups_within_columns^0|0|6|6|1D|8|P|M|0|0|5|8|0|0|2B|1|U|T|1|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@$D|12|E|13|F|G]|$D|14|E|15|F|G]]|9|@$D|16|E|17|1|18]]|A|$]]|$1|H|3|I|5|6|7|19|8|@$D|1A|E|1B|F|G]]|9|@]|A|$]]|$1|J|3|K|5|L|7|1C|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|1D|8|@$D|1E|E|1F|F|G]]|9|@$D|1G|E|1H|1|1I]]|A|$]]|$1|Q|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]|Y|$5|T|U|V|A|$W|Z]]]]

SQLite does not contain regular expression functionality by default.

It defines a <code>REGEXP</code> operator, but this will fail with an error message unless you or your framework <a href="http://www.sqlite.org/c3ref/create_function.html" rel="noreferrer">define a user function</a> called <code>regexp()</code>. How you do this will depend on your platform.

If you have a <code>regexp()</code> function defined, you can match an arbitrary integer from a comma-separated list like so:

<pre><code>... WHERE your_column REGEXP "\b" || your_integer || "\b";
</code></pre>

But really, it looks like you would find things a whole lot easier if you <a href="http://en.wikipedia.org/wiki/Database_normalization" rel="noreferrer">normalised your database structure</a> by replacing those <a href="http://en.wikipedia.org/wiki/First_normal_form#Repeating_groups_within_columns" rel="noreferrer">groups within a single column</a> with a separate row for each number in the comma-separated list. Then you could not only use the <code>=</code> operator instead of a regular expression, but also use more powerful relational tools like joins that SQL provides for you.

blocks|key|994132|text|REGEXP关键字的PHP/PDO中的SQLite+UDF，模拟MySQL中的行为：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|994133|$pdo->sqliteCreateFunction('regexp',
++++function+($pattern,+$data,+$delimiter+=+'~',+$modifiers+=+'isuS')
++++{
++++++++if+(isset($pattern,+$data)+===+true)
++++++++{
++++++++++++return+(preg_match(sprintf('%251$s%252$s%251$s%253$s',+$delimiter,+$pattern,+$modifiers),+$data)+>+0);
++++++++}

++++++++return+null;
++++}
);|code-block|syntax|javascript|994134|MySQL中没有实现u修饰符，但我发现在默认情况下使用它很有用。示例：|994135|SELECT+*+FROM+"table"+WHERE+"name"+REGEXP+'sql(ite)*';
SELECT+*+FROM+"table"+WHERE+regexp('sql(ite)*',+"name",+'#',+'s');|994136|如果$data或$pattern为NULL，则结果为NULL+-就像在MySQL中一样。|994137|entityMap^0|0|6|0|0|A|1|0|0|2|5|8|8|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|10|8|@$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|R|$]]

A SQLite UDF in PHP/PDO for the <code>REGEXP</code> keyword that mimics the behavior in MySQL: 

<pre><code>$pdo-&gt;sqliteCreateFunction('regexp',
 function ($pattern, $data, $delimiter = '~', $modifiers = 'isuS')
 {
 if (isset($pattern, $data) === true)
 {
 return (preg_match(sprintf('%1$s%2$s%1$s%3$s', $delimiter, $pattern, $modifiers), $data) &gt; 0);
 }

 return null;
 }
);
</code></pre>

The <code>u</code> modifier is not implemented in MySQL, but I find it useful to have it by default. Examples:

<pre><code>SELECT * FROM "table" WHERE "name" REGEXP 'sql(ite)*';
SELECT * FROM "table" WHERE regexp('sql(ite)*', "name", '#', 's');
</code></pre>

If either <code>$data</code> or <code>$pattern</code> is NULL, the result is NULL - just like in MySQL.

blocks|key|994180|text|我的Python+with+sqlite3解决方案|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|994181|import+sqlite3
import+re

def+match(expr,+item):
++++return+re.match(expr,+item)+is+not+None

conn+=+sqlite3.connect(':memory:')
conn.create_function("MATCHES",+2,+match)
cursor+=+conn.cursor()
cursor.execute("SELECT+MATCHES('%5Eb',+'busy');")
print+cursor.fetchone()[0]

cursor.close()
conn.close()|code-block|syntax|javascript|994182|如果正则表达式匹配，则输出将为1，否则为0。|994183|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_function^0|9|C|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

My solution in Python <a href="https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_function" rel="nofollow noreferrer">with sqlite3</a>:
<pre class="lang-py prettyprint-override"><code>import sqlite3
import re

def match(expr, item):
 return re.match(expr, item) is not None

conn = sqlite3.connect(':memory:')
conn.create_function(&quot;MATCHES&quot;, 2, match)
cursor = conn.cursor()
cursor.execute(&quot;SELECT MATCHES('^b', 'busy');&quot;)
print cursor.fetchone()[0]

cursor.close()
conn.close()
</code></pre>
If regex matches, the output would be 1, otherwise 0.

blocks|key|779945|text|对于python，假设con是到SQLite的连接，您可以通过以下代码定义所需的UDF：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|779946|con.create_function('regexp',+2,+lambda+x,+y:+1+if+re.search(x,y)+else+0)|code-block|syntax|javascript|779947|下面是一个更完整的示例：|779948|import+re
import+sqlite3

with+sqlite3.connect(":memory:")+as+con:
++++con.create_function('regexp',+2,+lambda+x,+y:+1+if+re.search(x,y)+else+0)
++++cursor+=+con.cursor()
++++#+...
++++cursor.execute("SELECT+*+from+person+WHERE+surname+REGEXP+'%5EA'+")|779949|entityMap^0|B|3|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

With python, assuming <code>con</code> is the connection to SQLite, you can define the required UDF by writing:

<pre><code>con.create_function('regexp', 2, lambda x, y: 1 if re.search(x,y) else 0)
</code></pre>

Here is a more complete example:

<pre><code>import re
import sqlite3

with sqlite3.connect(":memory:") as con:
 con.create_function('regexp', 2, lambda x, y: 1 if re.search(x,y) else 0)
 cursor = con.cursor()
 # ...
 cursor.execute("SELECT * from person WHERE surname REGEXP '^A' ")


</code></pre>

blocks|key|779846|text|一个详尽的或‘’ed子句可以在没有字符串连接的情况下做到这一点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|779847|WHERE+(+x+==+'3'+OR
++++++++x+LIKE+'%25,3'+OR
++++++++x+LIKE+'3,%25'+OR
++++++++x+LIKE+'%25,3,%25');|code-block|syntax|javascript|779848|包括完全匹配、列表结束、列表开始和中间列表四种情况。|779849|这更加冗长，不需要regex扩展。|779850|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

An exhaustive or'ed where clause can do it without string concatenation:

<pre><code>WHERE ( x == '3' OR
 x LIKE '%,3' OR
 x LIKE '3,%' OR
 x LIKE '%,3,%');
</code></pre>

Includes the four cases exact match, end of list, beginning of list, and mid list.

This is more verbose, doesn't require the regex extension.

blocks|key|994192|text|UPDATE+TableName
+SET+YourField+=+''
WHERE+YourField+REGEXP+'YOUR+REGEX'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|994193|和：|unstyled|994194|SELECT+*+from+TableName
+WHERE+YourField+REGEXP+'YOUR+REGEX'|994195|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>UPDATE TableName
 SET YourField = ''
WHERE YourField REGEXP 'YOUR REGEX'
</code></pre>

And :

<pre><code>SELECT * from TableName
 WHERE YourField REGEXP 'YOUR REGEX'
</code></pre>

blocks|key|993796|text|您可以将正则表达式与REGEXP一起使用，但这是一种进行精确匹配的愚蠢方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|993797|你应该直接说WHERE+x+=+'3'。|style|CODE|993798|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlite.org/lang_expr.html^0|A|6|0|0|6|D|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@$A|U|B|V|F|G]]|9|@]|C|$]]|$1|H|3|-4|5|6|7|W|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

You could use a regular expression with <a href="http://www.sqlite.org/lang_expr.html" rel="nofollow">REGEXP</a>, but that is a silly way to do an exact match.

You should just say <code>WHERE x = '3'</code>.

blocks|key|994249|text|你也可以考虑|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994250|WHERE+x+REGEXP+'(%5E%7C\D{1})3(\D{1}%7C$)'|code-block|syntax|javascript|994251|这将允许在任何位置的任何字符串中查找数字3|994252|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You may consider also 

<pre><code>WHERE x REGEXP '(^|\D{1})3(\D{1}|$)'
</code></pre>

This will allow find number 3 in any string at any position

blocks|key|780113|text|2021-06-18发布的SQLite版本3.36.0现在具有内置的REGEXP命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|780114|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

SQLite version 3.36.0 released 2021-06-18 now has the REGEXP command builtin.

blocks|key|779685|text|如果您使用的是php，您可以使用：SQLite3::createFunction将任何函数添加到sql语句中。在PDO中，您可以使用PDO::sqliteCreateFunction并在语句中实现preg_match函数：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|779686|看看Havalite如何做到这一点(RegExp+in+SqLite+using+Php)|779687|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/sqlite3.createfunction.php|1|http://php.net/manual/en/pdo.sqlitecreatefunction.php|2|http://www.php.net/manual/en/function.preg-match.php|3|http://www.havalite.com/?p=98^0|H|N|0|1U|P|1|2Q|A|2|0|I|Q|3|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]|$A|X|B|Y|1|Z]|$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|F|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]|P|$5|I|J|K|C|$L|Q]]|R|$5|I|J|K|C|$L|S]]]]

If you are using php you can add any function to your sql statement by using: <a href="http://php.net/manual/en/sqlite3.createfunction.php" rel="nofollow">SQLite3::createFunction</a>.
In PDO you can use <a href="http://php.net/manual/en/pdo.sqlitecreatefunction.php" rel="nofollow">PDO::sqliteCreateFunction</a> and implement the <a href="http://www.php.net/manual/en/function.preg-match.php" rel="nofollow">preg_match</a> function within your statement:

See how its done by Havalite (<a href="http://www.havalite.com/?p=98" rel="nofollow">RegExp in SqLite using Php</a>)

blocks|key|994380|text|在Julia中，要遵循的模型可以如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|994381|using+SQLite
using+DataFrames

db+=+SQLite.DB("<name>.db")

register(db,+SQLite.regexp,+nargs=2,+name="regexp")

SQLite.Query(db,+"SELECT+*+FROM+test+WHERE+name+REGEXP+'%5Eh';")+%7C>+DataFrame|code-block|syntax|javascript|994382|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In Julia, the model to follow can be illustrated as follows:

<pre><code>using SQLite
using DataFrames

db = SQLite.DB("&lt;name&gt;.db")

register(db, SQLite.regexp, nargs=2, name="regexp")

SQLite.Query(db, "SELECT * FROM test WHERE name REGEXP '^h';") |&gt; DataFrame
</code></pre>

blocks|key|780066|text|对于rails|type|unstyled|depth|inlineStyleRanges|entityRanges|data|780067|++++++++++++db+=+ActiveRecord::Base.connection.raw_connection
++++++++++++db.create_function('regexp',+2)+do+%7Cfunc,+pattern,+expression%7C
++++++++++++++func.result+=+expression.to_s.match(Regexp.new(pattern.to_s,+Regexp::IGNORECASE))+?+1+:+0
++++++++++++end|code-block|syntax|javascript|780068|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

for rails

<pre class="lang-rb prettyprint-override"><code> db = ActiveRecord::Base.connection.raw_connection
 db.create_function('regexp', 2) do |func, pattern, expression|
 func.result = expression.to_s.match(Regexp.new(pattern.to_s, Regexp::IGNORECASE)) ? 1 : 0
 end
</code></pre>

I'd like to use a regular expression in sqlite, but I don't know how.

My table has got a column with strings like this: "3,12,13,14,19,28,32"
Now if I type "where x LIKE '3'" I also get the rows which contain values like 13 or 32,
but I'd like to get only the rows which have exactly the value 3 in that string.

Does anyone know how to solve this?

How do I use regex in a SQLite query?

数据库

Windows

SQLite

Python

Ubuntu

MySQL

Julia

Perl

我想在sqlite中使用正则表达式，但我不知道如何使用。我的表中有一列包含这样的字符串："3,12, 13 ,14,19,28, 32“现在，如果我输入"where x like '3'”，我也会得到包含13或32这样的值的行，但我只想得到字符串中恰好包含值3的行。有人知道怎么解决这个问题吗？

问如何在SQLite查询中使用正则表达式？
EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQLite查询中使用正则表达式？EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在SQLite查询中使用正则表达式？
EN