Ive been looking around and havent been able to find anything like this yet.. I am new to mySQL.
Im looking for a function like the "where" function of a query string.. but insted of it being exact i would like to select "where" datafield "contains" text..
item is listed under multiple states
id=1 name=apple state=FL, WI, CA
id=2 name=orange state=FL
when displaying results i would like to have apple come up when i select any of the states that it is listed under..