Match a value from array of values in mysql

qwerturk

New Member
I have a query like this :\[code\]$sql = " SELECT * FROM tbl_emp_data WHERE company_qualification = '$q' ";\[/code\]Now my \[code\]company_qualification\[/code\] field is not a single value ,instead its a words separated by commas like \[code\]BSc,BA,BCom\[/code\] etc . And the value \[code\]$q\[/code\] is a single value say \[code\]BA\[/code\] . So how can I search the company data from the value \[code\]$q\[/code\] . I can not use \[code\]LIKE\[/code\] since its going to match fields like \[code\]BA\[/code\] and \[code\]BBA\[/code\] .
 
Top