match character in specific position

[Alicia]

Hi,

 

If I want to use a query to do matching for second character in a column, how should I go about to get this done?

 

E.g : I want so search which records has 8 as second character of the entry in a table.

 

e.g :

1234

1281

1881

2899

 

Then it will show the results for 1881 and 2899 since both has the character in the second position.

 

I tried to use substr function but it is not working. Please advise and thanks.

 

 

[Alex]

You can use a LIKE, and within a like you can use _ to match one character and % to match 0 or more, so something like this should do:

 

SELECT column FROM table WHERE column LIKE '_8%'