Oracle function similar to the LIKE condition, but REGEXP_LIKE performs regular expression pattern matching. See also REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR and REGEXP_COUNT for other functions extended to use regular expressions.
Questions tagged [regexp-like]
199 questions
-2
votes
1 answer
How to detect the number of distinct words in a string with Regex?
I would like to detect if a string contains multiple different words and would like to limit the number of words. Words all kinds of characters, except spaces.
E.g.: I want to check if the following strings have no more than three distinct…
AVS
- 99
- 2
- 11
-2
votes
1 answer
How to exclude records from Regular Expression condition in WHERE clause
In one of my query I do not want Regular Expression condition in WHERE clause. It means the query should exclude Regular expression condition.
Eg:- select ........ where regexp_like(col, '[a-zA-Z0-9]\.[a-zA-Z0-9]')
whatever we are getting records…
Shahin P
- 372
- 1
- 4
- 14
-3
votes
1 answer
REGEXP_LIKE in Postgresql
I have a table to store substitutions which is including two fields, the first one is to store the word, the second is to store the substitutions. I know the creation of the table is not a suitable approach, but it is already in place and used by…
John Barton
- 1,581
- 4
- 25
- 51
-4
votes
1 answer
MySQL | Regular expressions (Regexp)
Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.
Input Format
The STATION table is described as follows:
station table
Select distinct city from station where city REGEXP…
