Query about ', ' split string

Often encounter such as ' 1,4,7,5,36,14 ' such a string, in the database how to deal with it?!

Order

ID Name Total Goodids

1 orders 1 5 4,14,6,7,46

2 Orders 2 7 1,11,111,32,24

3 Orders 3 3 1,14,7

4 Orders 4 4 1, 13, 4,7

Single lookup: Find the order with the inclusion Goodid 1

1. SELECT * from order where CONCAT (', ', ' goodids, ', ') like CONCAT ('%, ', 1, ',% ')

2. SELECT * from order where Find_in_set (' 1 ', goodids);

There is a need: the number of statistics Goodid >3

1. SELECT * from order where goodids like '%,%,%,% '

2. SELECT * from order where goodids REGEXP ' ([0-9]+,) {3} '---this is a regular match

Query about ', ' split string