I have a table - Product.
Product.Keywords is a csv list of entries. I want to be able to pull out all of the Product records whose first entry in that field matches the first entry in the field of the Product record I currently have available.
IE keyword of my product is (say) "fish, chips, peas". I want all the products whose first keyword is "fish" but excluding my original product.
How do i write PHP/MYSQL Code to search on the first value of a database field that is stored as a csv list?
LIKE 'fish%'
garden ridge
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment