over 4 years ago
<-- Chapter 9: SQL != Operator
LIKE Operator Example
WHERE `name` LIKE '%HI%';
Now Run this Query, we will see the output below :-
We can see here, that only the record is displayed which column name value matches the pattern "HI" . LIKE Operator has some other functioning also. Lets see those Examples too below :-
WHERE `designation` LIKE 's%';
We can see here, that only the record is displayed which column designation value starts with the letter "s".Lets see the other Example below
WHERE `designation` LIKE '%er';
We can see here, that only the record is displayed which column designation value ends with the letter "er".
Chapter 11: SQL BETWEEN Operator -->
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
© copyright 2017 FindNerd.com. All rights reserved.
Sign up using