I have a query like this :
$sql = "
SELECT
*
FROM
tbl_emp_data
WHERE
company_qualification = '$q'
";
Now my company_qualification field is not a single value ,instead its a words separated by commas like BSc,BA,BCom etc . And the value $q is a single value say BA . So how can I search the company data from the value $q . I can not use LIKE since its going to match fields like BA and BBA .
You can use FIND_IN_SET
$sql = "
SELECT
*
FROM
tbl_emp_data
WHERE
FIND_IN_SET($q,company_qualification)
";
SELECT * FROM tbl_emp_data WHERE FIND_IN_SET(B.A,company_qualification) LIMIT 0, 10 
B.A is a string and must be surrounded by the single or double quote. put the '$q' in single quote and also make sure you are escaping user inputs before substituting them with query.$sql = "
SELECT
*
FROM
tbl_emp_data
WHERE
company_qualification IN ('".implode("','",$q)."')
";
You can use IN like this:
SELECT * FROM tbl_emp_data WHERE company_qualification IN ('BSc', 'BA', 'BCom');
