Alicia Posted November 20, 2009 Share Posted November 20, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/182245-match-character-in-specific-position/ Share on other sites More sharing options...
Alex Posted November 20, 2009 Share Posted November 20, 2009 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%' Quote Link to comment https://forums.phpfreaks.com/topic/182245-match-character-in-specific-position/#findComment-961667 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.