Menu

#101 Add REGEXP regular expression comparison

open
nobody
None
5
2016-06-07
2016-06-07
No

Add REGEXP comparison, similar to a SQL LIKE expression, but matching a string against a regular expression (in java.util.regex.Pattern format) instead.

For example,

SELECT * FROM t1 WHERE RefId REGEXP '^[0-9]{6}$'

SELECT * FROM t2 WHERE Partnum NOT REGEXP 'XXX-(11|22|50|99|100)'

Other databases such as sqlite and MySQL have REGEXP. PostgreSQL has ~ to perform a regular expression matching.

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.