subquery question

[mapleleaf]

I have an articles table with a tag field and a theme field.(and other fields)

The theme field takes a single theme_id. Themes are in their own table.

I want to pull all the articles that have duplicated the theme name in their tags. Tags are comma separated.

It seems like it would be easy but....

 

Pseudo:

SELECT * FROM articles, themes WHERE themes.theme like '%articles.tags%'

 

Tx

 

 

[fenway]

First problem -- no join condition.

 

Second problem -- what's being stored in the "theme" column?? I'm confused.

[riwan]

Well, I think your field is reversed, the one on the left side of LIKE should be articles.tags

 

I would think below is what you want

SELECT *
FROM `articles` , themes
WHERE articles.tags LIKE CONCAT( '%_', themes.theme, '_%' )

[mapleleaf]

Riwan that is what I needed. thanks.

theme was the theme name by the way fenway.

Tx to both