Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id | username | ... |
- ----------------------
- 1 | name1cat | ... |
- 2 | cat | ... |
- 3 | name4 | ... |
- 4 | test | ... |
- id | product_name | user_id | end_date | active |
- ---------------------------------------------------
- 1 | good cat | 1 | 2019-07-15 | t |
- 2 | good dog | 4 | 2019-07-20 | t |
- 3 | cat | 3 | 2019-07-20 | t |
- 4 | good phone | 2 | 2019-07-20 | f |
- SELECT P.PRODUCT_ID, P.PRODUCT_NAME, U.USER_ID
- FROM PRODUCTS AS P
- LEFT JOIN USERS AS U ON (U.USER_ID = P.USER_ID)
- WHERE
- P.ACTIVE = TRUE
- AND P.END_DATE >= NOW()
- AND LOWER(P.PRODUCT_NAME) LIKE LOWER('%cat%') OR LOWER(U.USERNAME) LIKE LOWER('%cat%')
- GROUP BY P.PRODUCT_ID, U.USER_ID
- id | product_name | user_id | PRODUCT_NAME | end_date | active |
- ------------------------------------------------------------------
- 1 | cat | 3 | name4 | 2019-07-20 | t |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement