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
.