export to csv records with value "like" in one table

Just not getting it to work

[nippi]

I'm trying to run a comman on a mysql database to export all reco have "baby" in the category table, baby being contained in all the categories i want to export.

cant work out the syntax, yes i've read the manual, but am too much of a newb and cant get it to work.

[whoisgregg]

Is this what you're looking for?

SELECT * FROM `product` WHERE `category` LIKE '%baby%'

Or are you trying to find rows based on multiple tables?