The regular-expression tag has no wiki summary.
1
vote
0answers
59 views
Regular Expression Integrity Constraints in SQLite3
In a SQLite3 CREATE TABLE statement, can I use a regular expression to enforce a particular constraint? Specifically, I am trying to require that an inputted URL is valid. I know there are other ways ...
0
votes
0answers
334 views
How to use SUBSTRING using REGEXP in MySQL
I have the following situation. I have to substring regular expression from description using MySQL.
Description:
Lorem D9801 ipsum dolor sit amet
Where D9801 is REGEXP. Every strong text ...
0
votes
1answer
127 views
RegEx bug in MongoDB
I run the following queries on a collection that have a lot of entries that contain [ and ].
db.test.find({word:/[\[]/}); // could not be run in console
db.test.find({word:/\[/ }); ...
2
votes
1answer
56 views
Regular Expression Difficulty
I'm trying to extract 456 from the string :123:456: as follows:
select regexp_substr(':123:456:', ':(\d+):', 1, 2, 'i', 1) from dual
However, this query returns null. What am I doing wrong?
0
votes
1answer
76 views
Regular expression problem
SELECT FIRSTNAME,LASTNAME, EMAIL
FROM CUSTOMERS
WHERE REGEXP_LIKE(EMAIL,'[A-Z0-9._%-]{1,10}@[a-z0-9._%-]{1,5}\.[net|com]','i');
I know this is not practical or make a ton of sense, but its a ...
6
votes
4answers
3k views
Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
I had to write a simple query where I go looking for people's name that start with a B or a D :
SELECT s.name from
spelers s
WHERE s.name LIKE 'B%' or s.name like 'D%'
order by 1
I was wondering ...
1
vote
1answer
356 views
sp_OACreate vbscript.regexp Class not registered
Imagine a Windows Server 2003 Enterprise x64 Edition.
I can create a 'vbscript.regexp' object using a vbscript (confirming that the DLL is registered).
I cannot create a 'vbscript.regexp' object ...
4
votes
1answer
210 views
How do I use the POSIX character classes upper and lower to search text in MySQL?
I would like to search a body of text to find out when a specific word has been upper cased. MySQL has a REGEXP function with the POSIX character class [[:upper:]], but for the life of me I can't get ...
3
votes
2answers
3k views
Emulate REGEXP like behaviour in SQL
I posted the same on stackoverflow (please, let me know if I have to delete one).
I'm working on a DB2 database and as far as I can see regexp is not supported (without additional libraries).
So I ...
3
votes
1answer
3k views
How can I query names using regular expressions?
How could I search for a specific pattern in a column?
For example, I like to get all user names that start with either letter A or B.
(btw: this is tagged oracle, but it might be interesting in ...
