Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM `restaurant_session_log`
- WHERE `restId` = '176'
- OR branchId = '203'
- OR `multi_vendorId` LIKE '%,176%'
- OR `multi_vendorId` LIKE '%,176,%'
- OR `multi_vendorId` LIKE '%176,%'
- OR `multi_vendorId` LIKE '%[176]%'
- AND (`excluded_branch_id` NOT LIKE '%,203%' OR `excluded_branch_id` NOT LIKE '%,203,%' OR `excluded_branch_id` NOT LIKE '%203,%' OR `excluded_branch_id` NOT LIKE '%[203]%' )
- WHERE (`restId` = '176' OR branchId = '203'
- find_in_set(176, `multi_vendorId`)
- ) AND
- (find_in_set(203, `excluded_branch_id`)
Add Comment
Please, Sign In to add comment