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 Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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.