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 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. 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
Archived
This topic is now archived and is closed to further replies.