multiple LIKE in a select statement?

[barcsdad]

This seems like it should work, but it doesn't. It seems to only return one of the conditions. When I try running the query in DBTools query editor, it works fine. However, not in my site. I'm running the latest MySQL.

$query = "SELECT * FROM graphics WHERE avail_industries LIKE '%15%' AND avail_templates LIKE '%34%'";

Marty

[tomhath]

It has to be either a data issue (what you think is in the database is not what's actually there), or you're not running the same query in both places. Don't assume anything.