![]() ![]() ![]() “ _om”, “ T_m”, or “ To_”, are all valid patterns. The underscore wildcard can be placed anywhere in the pattern you are looking for. By placing two underscores after “ Wa”, we explicitly specify that the LastName we are looking for is 4 characters long. Notice how Andrew Wade matches the pattern but not Tom Waters. This time, we will substitute two characters with two underscore ( _) wildcard characters.Įxecuting this query retrieves a single record from our table. Our SQL query is ignoring that letter and looking for the pattern we have specified. Notice how the second letter of the name can be anything.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |