BuboFlash - helps with learning

Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.

Presentation
Question

Answer

Question

This SQL Server LIKE condition example would return all employees whose first_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th', and the third character is either 'i' or 'y'. So in this case, it would match on either 'Smith' or 'Smyth'.

Answer

SELECT *
FROM employees
WHERE first_name LIKE 'Sm[iy]th';

Question

Answer

Question

Answer

SELECT *
FROM employees
WHERE first_name LIKE 'Sm[iy]th';

If you want to change selection, open document below and click on "Move attachment"

SQL Server: LIKE Condition
ldcard (square brackets wildcard) works in the SQL Server LIKE condition. Remember that what is contained within the square brackets are characters that you are trying to match on. For example: <span>SELECT * FROM employees WHERE first_name LIKE 'Sm[iy]th'; This SQL Server LIKE condition example would return all employees whose first_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th', and the third character is either 'i' or 'y'. So in this case, it would match on either 'Smith' or 'Smyth'. Example - Using [^] wildcard (square brackets with ^ wildcard) Next, let's explain how the [^] wildcard (square brackets with ^ wildcard) works in the SQL Server LIKE condition. Remembe

Summary

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.