mysql中的字符串拆分和子查询

Question

first of all i have 1 table in database.

1)tags :

id    name
1     theme1=test1
2     theme1=test2
3     theme1=test3
4     theme2=test1
5     theme2=test2
6     theme2=test3

And i have bunch of id of tags in array. like 1,3.

Now,

1)select name from tags where id=1

result: theme1=test1

(now using wildcard)

2)select id from tags where name like 'theme_test1'

result : 1,4

(here 'theme_test1' need to take from query1)

I am getting output proper but need to use 2 query.I want to do this in single query.

Thanks

Answer 1

SELECT id FROM tags WHERE name LIKE ( 
    SELECT CONCAT(SUBSTRING(name,1,5),'__',SUBSTRING(name,8)) FROM tags WHERE id=1 
)

Returns 1,4

But Two queries (or a refactor) might be a better option