[RESOLVED] Matching multiple rows

[Shawazi]

I am completely unsure if this is correct. I have a table like this

item_id | tag

5 mansell
6 musical
5 music

If someone searches the word "music" I want to find both item 6 and 5.

I am thinking something like

item_id IN
(
   SELECT item_id FROM table WHERE tag LIKE 'music%'
  OR MATCH(tag) AGAINST ('music' IN BOOLEAN MODE))
)

Does this seem to be proper?

[MattG]

Yep, LIKE 'music%' would work and find everything that starts with the word/letters music

[Shawazi]

Okay I suppose if no one thinks there's a more efficient way I'll go with that. I was just copy pasting from my coworkers code to be honest who deals with this more than I. 🙂