MySQL search comma separated keywords
If you must keep keywords as a CSV, you can use FIND_IN_SET().

SELECT COUNT(*) as num 
FROM table 
WHERE FIND_IN_SET('hello', keywords) 
AND FIND_IN_SET('world', keywords);