split MYSQL field into array and search : <p>I have field in MySQL table. The field is called 'vehicles' When I add vehicles I add them by ID not name, so the field is populated like '2:3:4:6:7:9' 2 will be a car, 7 will be a bike, etc. </p>

<p>What I want to do quickly and simply is when I query the table I want to see if the field vehicle contains '2' is in that field within the 2:3:4:7:9. </p>

<p>I have tried a lot but coming up blank?</p>

<p>Thanks</p>
