add , to the end and start also

so value becomes , truck, heavy truck, others,

use this query

select truckType from table where trackType like '%, truck,%

NOTE: , in like '%, truck,%'

you should make a separate table:

------------------
typeId | type        |
-----------------
1      | truck       |
2      | heavy truck |
....

Also table for entity:

------------------
entityid |         |
-----------------
1        | entity1 |
2        | entity2 |

and other table will have multiple to one relationship with this table:

-------------------------------
id | typeId      | entityId    |
-------------------------------
1  | 1           | 2           |
2  | 2           | 2           |
2  | 2           | 1           |

And your select would be a join of this two tables.