Question: I want to put a condition in my query where I have a column that should contain second position as an alphabet.

How to achieve this?

I've tried with `_[A-Z]%` in where clause but is not working. I've also tried `[A-Z]%`.

Any inputs please?

Answer: 
I think you want mysql query. like this

```
SELECT * FROM table WHERE column REGEXP '^.[A-Za-z]+$'

```

or sql server

```
select * from table  where  column like '_[a-zA-Z]%'

```
You can use regular expression matching in your query. For example:

```
SELECT * FROM `test` WHERE `name` REGEXP '^.[a-zA-Z].*';

```

That would match the `name` column from the `test` table against a regex that verifies if the second character is either a lowercase or uppercase alphabet letter.

Also see this [SQL Fiddle](http://sqlfiddle.com/#!9/92b72/3) for an example of data it does and doesn't match.