essjay_d12 Posted April 23, 2006 Share Posted April 23, 2006 What does % do in the WHERE something LIKE clause and what are the others I can use, is there a full list that would be accessible to me?thanksd Quote Link to comment https://forums.phpfreaks.com/topic/8182-or-_-in-the-where-variable-like-clause/ Share on other sites More sharing options...
fenway Posted April 23, 2006 Share Posted April 23, 2006 This is a wildcard character that matches any number of characters. There's also the underscore (_), which matches a single characters. These let you find anothing that starts with 'q', or is a two-letter word starting with 'a', etc. Kind of like * and . in Perl regexs. Speaking of which, you can also match on regexs... the refman has a laundry list of the ones available. Just remember that indexes get become totally useless when you use these, so use with caution. Quote Link to comment https://forums.phpfreaks.com/topic/8182-or-_-in-the-where-variable-like-clause/#findComment-29862 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.