about 7 years ago
LIKE Operator:
It is used to search for pattern in a table or a database . It is used with where condition. It is similar to REGEXP of MySQL.
Syntax:
SELECT columnname(s) FROM tablename WHERE columnname LIKE pattern-condition;
Example1:
SELECT Name FROM Employee WHERE Address LIKE 'r%';
The above query will select those Employee names whose address start with letter "r" like rishikesh etc.
Example2:
SELECT Name FROM Employee WHERE Address LIKE '%a';
The above query will select those Employee names whose address ends with letter "a" like noida,america etc.
Example3:
SELECT Name FROM Employee WHERE Address LIKE '%arid%';
The above query will select those Employee names whose address contains substring "arid" like haridwar etc.
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?
Sign up using
0 Comment(s)