匹配mysql中值数组的值

Question

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 .

Answer 1

You can use FIND_IN_SET

$sql = "
        SELECT
            *
        FROM
            tbl_emp_data
        WHERE        
           FIND_IN_SET($q,company_qualification)
    ";