Code:
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).
Thread: Regular Expressions Help  |
|||||||||||||
|
Started 1 month, 2 weeks ago by 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...
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread:
ssma replied 1 month, 2 weeks ago
Thank you very much
Size: 19 bytes
Customize: 
|
Top contributing authorsRelated threads on "CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions":Related threads on other sites: |
||||||||||||
Thread profile page for "Regular Expressions Help" on http://www.codeguru.com.
This report page is a snippet summary view from a single thread "Regular Expressions Help", located on the Message Board at http://www.codeguru.com.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.