multiple values in a field of a record
Posted: Tue Apr 20, 2004 7:41 pm
I have a table with information on plants, with a field in it called state.
A plant can be in many states, so i have a value in the field 'CA LA WI' and so on, for example. Then, if i'm looking for plants in the area, i select where state like %CA% and get the plants that way, displaying the results with my php page in a table.
Is there a way to delete a value from the field, say, delete LA from the value above?
Thanks
A plant can be in many states, so i have a value in the field 'CA LA WI' and so on, for example. Then, if i'm looking for plants in the area, i select where state like %CA% and get the plants that way, displaying the results with my php page in a table.
Is there a way to delete a value from the field, say, delete LA from the value above?
Thanks