Regular Expressions Help

[ssma]

Hi all,

I am new to oracle sql, so I am having a lil' bit of hard time to understand the regular expression part. I have a table that contains last name and email address and would like to select the emails that match the last the name, for example select smith if his email is smith@xy.com
I wrote the following query but it doesn't seem to be working, I would greatly appreciate any help

SELECT lname
FROM member
WHERE REGEXP_LIKE(email, lname||'^@') ;


Thanks

[jcaccia]

SELECT lname
FROM member
WHERE REGEXP_LIKE(email, lname||'@.+')

This selects all records where the email is the surname followed by '@' followed by any number of any characters (must have at least one).

[ssma]

Thank you very much