Can anyone help me to matching one column databases from another colunm databases.
For example:
The below table name is domains
Expand|Select|Wrap|Line Numbers
- ----------------------------------------------------------
- id | name | domains
- ---|--------|---------------------------------------------
- 1 | tamil | example1.com
- | |
- 2 | bala | example2.com
- | |
- 3 | ramu | example3.com
- | |
- 4 | ravi | example4.com
- | |
- | |
- | |
- ----------------------------------------------------------
The below table name is : notifications
Expand|Select|Wrap|Line Numbers
- ----------------------------------------------------------
- id | domain | notifications
- ---|---------------|--------------------------------------
- 1 | example1.com | notification1
- | |
- 2 | example2.com | notification2
- | |
- 3 | example3.com | notification3
- | |
- 4 | example4.com | notification4
- | |
- | |
- | |
- ----------------------------------------------------------
My question is,
Tamil, bala, ramu, ravi are the users in my website
every one having each domains in their account which is mentioned in the domains table
tamil is having domain name example1.com,
bala is having domain name example2.com,
ramu is having domain name example3.com,
ravi is having domain name example4.com
I want to get the result of notifications column from the notifications table if any domains are matching from the domains column in the domains table with the domain column of the notification table.
Finally, I want get the notification results
(I am creating this for who are the users logged with their account notifications should get matching domains from first table to second table of the user)
I think my question is understood to everyone, please help me friends...
Thank You