Hello

in a mysql table there is a piece of data under POSITIONS column 'TECHNICAL ASSISTANT (ENVIRONMENTAL)'

i have a piece of string 'MANAGER ENVIRONMENTAL ENGINEERING'.
i want a query when issued, this string should match the above.

currently i am using the below query.

Code:
SELECT * FROM TABLENAME
WHERE POSITIONS LIKE '%MANAGER ENVIRONMENTAL ENGINEERING%'
OR   POSITIONS LIKE '%MANAGER ENVIRONMENTAL ENGINEERING'
OR POSITIONS LIKE 'MANAGER ENVIRONMENTAL ENGINEERING%'
But it's not matching. Please help