Question: Hi im trying to use Sql within MySql to sort some values and this is what I have:

Select from my table the rows where the value in column status equals online and the value in column tags equals museum, order them by name and in ascending order.

```
SELECT *
  FROM tech
 WHERE `STATUS` = 'online'
   AND `TAGS` = 'museum'
ORDER BY NAME ASC

```

However what I need is this:

Select from my table the rows where the value in column status equals online **and there is this value in column tags that equals museum**, order them by name and in ascending order.

What I means is that right now in my DB my column tags only has one value per row, not very useful for using as tags. I want to change it so that the value in it would instead of "museum" be "museum 3d programming" and SQL check for a particular "word" in that string value.

Can it be done?

Answer: 
Try

```
SELECT *
  FROM tech
 WHERE `STATUS` = 'online'
   AND `TAGS` like '%museum%'
ORDER BY NAME ASC

```
You just have to use `LIKE` and `%`. See [this site](http://www.techonthenet.com/sql/like.php).

So something like this

```
..AND `TAGS` like '%museum%'...

```