AV1611 Posted May 17, 2006 Share Posted May 17, 2006 Need to find all records where the third digit is a Pselect * from table wherer field like '__P%' --> I thougth mysql used _ for a placeholder, but no returnsIf I do like '%P%' I get too many...??P? is not valid I don't think...How? Quote Link to comment https://forums.phpfreaks.com/topic/9862-simple-query/ Share on other sites More sharing options...
ryanlwh Posted May 17, 2006 Share Posted May 17, 2006 it should work. maybe there're whitespaces before the string so P is not really the 3rd character?[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] [color=red]'TEsTing'[/color] [color=orange]LIKE[/color] [color=red]'__S%'[/color]; [!--sql2--][/div][!--sql3--]returned true for me. Quote Link to comment https://forums.phpfreaks.com/topic/9862-simple-query/#findComment-36651 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.