在SQLITE SELECT语句中使用的自定义REGEXP函数 [英] Custom REGEXP Function to be used in a SQLITE SELECT Statement
问题描述
我有一个SQLITE数据库文件,在表列之一中有一些简单的正则表达式.
I have an SQLITE Database's File which in one of the table columns there is some simple Regular Expressions.
这些表达式类似于/foo(.?)或/foo/bar/(.?)等.
These Expressions are something like /foo(.?) or /foo/bar/(.?) and so on...
好吧,当我们尝试将某些文本与常规模式匹配时,在PHP中,我们这样做:
Well, when we try to match some text against a Regular Pattern, in PHP, we do:
preg_match($ pattern,$ target,$ matches)
preg_match( $pattern, $target, $matches )
显然,用内容替换了变量.
Replacing the variables with the content, obviously.
我想做的是发送任何STRING作为WHERE子句的值,并且在搜索SQLITE数据库的文件时,使用每个存储的正则表达式来匹配给定字符串中的模式.
What I would like to do is send ANY STRING as value of a WHERE Clause and, when searching the SQLITE Database's File, use each of the stored Regular Expressions to match a pattern in the given string.
我认为使用PHP的sqlite_create_function()可以创建某种例程来执行此操作,但是我不知道具体如何做,因为这是我第一次使用SQLITE进行开发.
I think that using PHP's sqlite_create_function() I can create some kind of routine to do this, but I don't know exactly how, since is the first time I develop using SQLITE.
如果有兴趣,它是我正在开发的框架的MVC路由的一部分.
If interest, it's part of an MVC Routing of a Framework I'm developing.
非常感谢您.
推荐答案
您可以使用SQLiteDatabase::createFunction
文档此处
You can use SQLiteDatabase::createFunction
documentation here or PDO::sqliteCreateFunction
documentation here
我做了这样的事情:
<?php
function _sqliteRegexp($string, $pattern) {
if(preg_match('/^'.$pattern.'$/i', $string)) {
return true;
}
return false;
}
$PDO->sqliteCreateFunction('regexp', '_sqliteRegexp', 2);
?>
使用:
SELECT route FROM routes WHERE pattern REGEXP 'your/url/string' LIMIT 1
这篇关于在SQLITE SELECT语句中使用的自定义REGEXP函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!