Mysql query returns 0

Question

I have a following query with subquery that returns no result

SELECT 'Message'
FROM message
WHERE ID in (
SELECT 'Message_id'
FROM user_message
WHERE 'status' =false )

Data in both tables is present. What could be the problem?

Answer 1

Why are you using a sub-query?

Why not

SELECT Message
FROM message JOIN user_message ON ID = Message_id
WHERE status = false

Seems simpler