CODEWITHSUNDEEP
mysqlsqldatabase
dev1234
dev1234

Reputation: 5706

Sql sub query with addition

I want to get the id's like in the query i wrote here.

SELECT id 
FROM `ActivityLog` 
WHERE `activityAt` >= '2015-01-23 00:00:00' 
AND `module` LIKE 'Api' 
AND `data` LIKE '%"status":false%' 
AND ( `action` LIKE 'DeviceSignUp'  OR  `action` LIKE 'UniversityStudentSignUp')

For these id's i want to add 1 and search them all.

for example, if my query returns 10,12,14,16 i want to add 1 to each and search for 11,13,15,17 through in query.

SELECT *
 FROM `ActivityLog`
 WHERE id in (11,13,15,17);

how is it possible to do the addition part ?

Upvotes: 0

Views: 36

Answers (1)

Taras Velykyy
Taras Velykyy

Reputation: 1801

SELECT * FROM ActivityLog WHERE id in 
(
  SELECT id + 1 FROM ActivityLog 
  WHERE activityAt >= '2015-01-23 00:00:00' 
   AND module LIKE 'Api' AND data LIKE '%"status":false%' 
   AND ( action LIKE 'DeviceSignUp' OR  action LIKE 'UniversityStudentSignUp' )
)

Upvotes: 3

Related Questions