Join Bill Weinman for an in-depth discussion in this video Filtering results with LIKE and IN, part of MySQL Essential Training (2014).
…The where clause also supports two operators that are specific to SQL, the…like operator is used to match particular values or patterns in a column.…Let's take a look at this, we'll use the world database here, so using the like…operator, i can do something like this, SELECT Name, Continent.…And population from country where name like, and give it a pattern.…
We'll order by name.…So when I press go, we'll get a list of the 18 rows that…match this pattern where the word island is somewhere in the name.…So we have all of these names that have the…word island or islands because, island is included in islands.…So Virgin Islands, we have the Sandwich Islands, Solomon Islands, Norfolk Island.…All of those have the word island in them someplace.…So you'll notice the percent signs.…
One there, and we have one here.…The percent sign is a wild card in this context.…It matches 0 or more characters in a row.…So by putting percent signs before and after the string.…I've matched all the strings with island anywhere in them.…
- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
1. Installing and Configuring the Test Environment
2. Basic Syntax
3. Creating a Database
4. MySQL Data Types
5. MySQL Functions
8. Subselects and Views
9. Stored Routines
10. PHP's PDO Interface with MySQL
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.