barkster Posted September 2, 2006 Share Posted September 2, 2006 I have a field that contains an underscore. How can I do a query for the underscore since I just found that underscore really doesn't find underscore it is a wildcard in mysql. I need to be able to query for the actual underscore. For example. Select Title where Title LIKE '10_%' doesn't give me what I want.Results10_1100_21000_410_2etc..Looking for Result "10_%"10_110_210_3Thanks Link to comment https://forums.phpfreaks.com/topic/19507-query-field-with-an-underscore-in-it/ Share on other sites More sharing options...
fenway Posted September 2, 2006 Share Posted September 2, 2006 The underscore is also a wildcard character (much like . in regexs) -- you need to escape it if you want to match an actual underscore. Link to comment https://forums.phpfreaks.com/topic/19507-query-field-with-an-underscore-in-it/#findComment-84838 Share on other sites More sharing options...
barkster Posted September 2, 2006 Author Share Posted September 2, 2006 Knew it had to be simple will try that Thanks Link to comment https://forums.phpfreaks.com/topic/19507-query-field-with-an-underscore-in-it/#findComment-84848 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.