Question: I want to write a sql query wherein the fourth letter should be `'x'` and there should be `'m'` anywhere in the whole word. I am having a list of over 5000 words.

I tried the command 

```
where name like '___x%m%'

```

but that would only give me those where `x` is the fourth letter and there is m after x, but how to find those names which have `x` as fourth letter and have `m` coming before `x`?

Answer: 
You can do this:

```
where name like '____x%' and name like '%m%'

```
Simply have the 2 conditions:

```
WHERE name LIKE '___x%' AND name LIKE '%m%'

```

Assuming the \_\_\_x part works for you.