Searching in a diffrent way

[ansharma]

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

[trq]

You would be much better off storing your data properly and not using comma separated values.