Stack Overflow
Stack Overflow

Questions tagged [rlike]

For issues relating to the RLIKE synonym for the REGEXP MySQL operator.

RLIKE is a synonym for the REGEXP MySQL operator. It performs a pattern match of a string expression against a pattern. The pattern is supplied as an argument.

Sample:

SELECT 'Michael!' REGEXP '.*';
64 questions
0
votes
2 answers

Mysql RLIKE - match end of string or another character

I'm trying to use RLIKE to match where a string of data is followed by either a specific character or an end of string ($). I get the expected results using just the end of string character ($), or just the expected character, or indeed any set of…
matt_platts
  • 23
  • 1
  • 7
0
votes
2 answers

java regex for nginx logs

I wish to transform my nginx logs using a reqular expression script as follows: original log: 07.21.99.178 - - [01/Jun/2012:12:06:23 +0530] "GET /api?playSessionId=live_21_bc206d95-113f-4b49-989b-7dff77af51c410.190.217.2111338532565422 HTTP/1.1" 200…
princess of persia
  • 2,222
  • 4
  • 26
  • 43
-1
votes
2 answers

rlike in scala dataframe is giving the error

I am trying to convert the below Hive SQL statement into Spark dataframe but getting an error. case when (lower(message_txt) rlike '.*sampletext(\\s?is\\s?)newtext.*' ) then 'P' else 'Y' Sample data: message_txt = "This is new sampletext, followed…
CNR
  • 11
  • 5
-3
votes
1 answer

RLIKE REGEX - Return given value without matching the spaces

I am trying to make a simple regex expression for a master search in my MYSQL query. All I want to do is return a match even if the value has spaces in it and my search value does not. E.G. If the user enters 'JoeBlogs' and I try to match this…
jimbo j
  • 1
1 2 3 4
5