I have it stored that way because it was the quickest way I could think of to store the data from a multiple select list on a form...the user needs to be able select multiple values on a list, and each value would then be entered into one column in the database using the implode function in php. which leads to my quandy - i need to select rows where the column has only a specific value. here is a more concrete example:
So far I have three rows, the applicable column that I am working is called areaexpertise. One row has the value "Residential," the second has "Residential/Commercial/Mortgage," and the third has "Mortgage." I need to select all data from each row (there is more than just this column) with "Residential" via an SQL statement.
substring() sounds as if it could be useful, but building on "SELECT * FROM agents" I'm not sure how to incorporate it.
