i have a regular expression that's supposed to match any string containing certain words in no particular order.
the pattern is in PHP:
var $pattern = /^(?=.*\bword1\b)(?=.*\bword2\b)(?=.*\bword3\b).*$/gmi
SELECT * FROM userbooks WHERE book_title REGEXP '^(\\?=.*[[:<:]]word1[[:>:]])(\\?=.*[[:<:]]word2[[:>:]])(\\?=.*[[:<:]]word3[[:>:]]).*$'
i also tried retrieving a book year which was 3333 using this code and it did not work either:
SELECT * FROM userbooks WHERE book_year REGEXP '33(\\?=33)'
is there any way to make this work or an alternative? or am i doing it wrong