querying the database for keywords

[Guest]

My site has thousands of categories and I am trying to figure out a way of pulling categories from the database where the categories_title contains certain keywords and then display the results on the product_listing page. In simple terms I want to do this:

 

In the database table “Categories_description” find “categories_title” that contain the word “my keyword”

 

Does anyone the equivalent php or sql code?

 

Thanks.

[Jack_mcs]

You would use something like

select categories_name from categories where categories_name like 'abc'

 

Jack

[Guest]

You would use something like

select categories_name from categories where categories_name like 'abc'

 

Jack

 

 

Thanks Jack, I'll give it a go. :)