Advice on how to do this please...

[Graham Mattingley]

Hello Group,

I have written an database of Greek holiday URL and web sites, this is how
it works

in my tables I have a field that represents the Greek island this is a
number field so for example Crete = 73 and Cyrpus = 72 etc etc,

at the moment, I have a single number in the island field, so for example I
search for links that relate to a certain Greekisland using the island_id
field

this field is "mediumint(8) unsigned"

I have an issue where a certain link might relate to 2 island, a business
might exist on 2 greek island, so my question is how can I have multi island
ids in the island id field and how do I search from them

I would like to be able to do some thing like this in the field 73,72,21,45
etc etc

I have tryed the command

Select **************** where island_id like '%73%';

and it seems to work fine, can anybody see any issues with this, or is this
the right to do this,

Can I use LIKE in a fulltext search ???

Thanks for your help

Graham Mattingley