My table looks like this

```
id, name
 1, ccc hij
 2, bbb
 3, hsd

```

Now if I query for `SELECT id, name FROM tbl WHERE name LIKE 'h%' OR '% h%';`

it gives me this as the output

```
id, name
1, ccc hij
3, hsd

```

Which is correct, but not in proper order. I can't even `ORDER BY name` since `ccc hij` would anyways get to top in natural sorting.

What option do I have to show item starting from user's keyword in the top and wildcard matches in the bottom?

**Update:**

Consider following input

```
1   ccc hij
2   hsd
3   hdb
4   haa

```

and the `order by (name LIKE 'h%') DESC` as suggested. I get following output

```
2   hsd
3   hdb
4   haa
1   ccc hij

```

Is is possible to sort `'h%'` matches alphabetically?