Problem with LIKE selection in query 2

[electricphp]

I have this query:

"SELECT * FROM ads WHERE cats LIKE'%$find%'"

lets say that $find is "Wines and Cheeses"

for some reason, it is selecting records that only have "wines" in them, so it will select "wines and beers"

How can I change this query so it only selects records that have the full string "Wines and Cheeses" in them

 

[electricphp]

yes it does, there is one other thing and since i have to reformat the whole db I may as well do it right.

There is another table called subcategories. This table is a subset of each individual category, so it references the categories table. So in reality I'm supposed to pick records that match the subcategories.

How should I modify the sql so it incorporates this other table, because in reality what I'm saying is select * from ads that match subcategories.

I don't think there will be any subcategories that will appear in more than one category, but I'm guessing to be thorough I should set it up to say select * from ads where category = "whatevercategories" AND subcategory = "whateversubcategories

 

[r937]

use just one table for both categories and subcategories, and no further changes are required

this might help -- Categories and Subcategories



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[electricphp]

ok thanks for your help

 

[electricphp]

How would i need to modify the following query

SELECT ads.*
FROM ad_categories
INNER
JOIN ads
ON ads.id = ad_categories.ad_id
WHERE ad_categories.cat_name = 'Wine and Cheeses'



If I had another table named ad_cities, that has the fields
"ad_id" and "city" in it, and has the same relashionships to the ads table as the ad_categories table has to the ads table?

And say I want to pull records that include wine and cheese and are in Boston

 

[r937]

SELECT ads.*
FROM ad_categories
INNER
JOIN ads
ON ads.id = ad_categories.ad_id
INNER
JOIN ad_cities
ON ad_cities.ad_id = ads.id
WHERE ad_categories.cat_name = 'Wine and Cheeses'
AND ad_cities.city = 'Boston'


r937.com | rudy.ca
Buy my new book Simply SQL from Amazon