MySQL 8 RLIKE and MySQL 5.x RLIKE
Posted by:
Liang Lee
Date: February 18, 2020 02:42PM
I have following query
SELECT DISTINCT title, details, id FROM table_name
WHERE (title RLIKE '[[:<:]]feedback[[:>:]]' OR details RLIKE '[[:<:]]feedback[[:>:]]')
This query works fine on MySQL 5.x but on MySQL 8.0 it is giving error
#3685 - Illegal argument to a regular expression.
I tried to search but no luck
Subject
Written By
Posted
MySQL 8 RLIKE and MySQL 5.x RLIKE
February 18, 2020 02:42PM
February 18, 2020 03:32PM
February 19, 2020 03:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.