Hi all
I have a table named `location` and have two fields `location_name` and `location_code`.
engine MYISAM, mysql version 5.5.8
location_name varchar(50),
location_code varchar(100)
i want to store multiple location_code with comma separated values like this
INSERT INTO `location` VALUES ('first location','01,05,08') , ('second location','02,04,07')
now if i want to search for all `location_name` where `location_code` are 01, 02, and any other code.
is there any way to search using in(), match against, any other but without using LIKE
add any index accordingly
Thanks