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.
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.
that's because there is no SUBSTR function in mysql, only a SUBSTRING function
Originally Posted by Ronan
and yes, it does work :)