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? 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. Link to comment https://forums.phpfreaks.com/topic/9862-simple-query/#findComment-36651 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.