over 5 years ago
It is similar to LIKE which is used to fetch data based on regular expression from a table.
SELECT columnname(s) FROM tablename WHERE columnname REGEXP pattern;
SELECT name FROM Employee WHERE name REGEXP 'sh$';
This query will find those names from Employee table who are ending with "sh". Like it will fetch name like Mahesh , Avnish etc.
SELECT name FROM Employee WHERE name REGEXP 'am';
This query will find those names from Employee table who contains "am" like Amit , Abraham 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?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using