Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Pattern Matching using REGEXP

    @suresh.ramola
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 463
    Comment on it

    REGEXP:

    It is similar to LIKE which is used to fetch data based on regular expression from a table.

    Syntax:

    1. SELECT  columnname(s) FROM  tablename WHERE columnname REGEXP pattern;

    Example 1:

    1. 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.

    Example 2:

    1. SELECT name FROM Employee WHERE name REGEXP 'am';

    This query will find those names from Employee table who contains "am" like Amit , Abraham etc.

    mysql Oracle sql
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: