正则表达式在数据库查询中的应用

SQL语句在数据库查询中具有非常重要的地位，但是标准的SQL语句在复杂的数据库查询中却存在着诸多不足。而正则表达式有着强大的查询功能，通过对正则表达式特殊字符以及数据库查询语言中谓词的分析，提出了将正则表达式运用于数据库查询当中的新查询方法，并对该方法在实际查询应用当中会遇到的几个普遍问题进行了探讨。从而证明该方法不仅可以降低查询语句的复杂程度而且还能简化对出错语句的修改工作。

Application of regular expression in database query

SQL sentences play an important role in database query. But there are many shortages while doing some complicated queries by the traditional SQL sentences. While the regular expression has the strong power in query, the special characters of the regular expression and the predication in the database query are analyzed. Then a new query method basis on regular expression is presented, and some common problems in application are probed into. With the application of this method the complication of the query sentences is reduced and the modifying of the error SQL sentences is simplified.