error 1146 Table 'projectb_pbn.posts' doesn't exist
SELECT *, ((CASE WHEN 'post_content' LIKE '%test%' THEN 1 ELSE 0 END) + (CASE WHEN 'post_content' LIKE '%string%' THEN 1 ELSE 0 END)) AS relevance FROM posts WHERE post_content LIKE '%test%' OR post_content LIKE '%string%' ORDER BY relevance DESC