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. 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%' 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
Archived
This topic is now archived and is closed to further replies.