Tag: mysql-regexp

Match specific string before user input

I have the following strings: SDZ420-1241242, AS42-9639263, SPF3-2352353 I want to “escape” the SDZ420- part while searching and only search using the last digits, so far I’ve tried RLIKE …

Regex to match duplicate/alias e-mails in MySQL

mysql mysql-regexp regex sql

I am trying to come up with some regular expression to check whether an e-mail exists in a database. What is more specific here is that I want to find e-mails that are the same, but might be written differently. E.g. john.doe@example.com is the same as johndode+123@example.com and j.o.h.n.d.o.e@example.com. Using another script I remove all dots and text after +