Home/ Questions/Q 3778
Next
In Process
Question
Ovilia
  • 0
Explorer
Asked: 2016-06-14T23:31:55+03:00 In:

How to combine “LIKE” and “IN” condition in sql ?

  • 0

Basically I want something as easy as 

WHERE something LIKE ('too%', '%noo%', 'sooo%')

instead of

WHERE something LIKE 'too%'
OR something LIKE '%noo%'
OR something LIKE 'sooo%'

Is there any possible way to combine these two things without writing complicated sub-selects?

conditionINLIKEoraclesql
Share

    Related Questions

    1 Answer

    1. Master Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant

      There is no combination of LIKE & IN in SQL, but you can use REGEXP_LIKE condition it’s similar LIKE condition, except REGEXP_LIKE performs regular expression matching instead of the simple pattern matching performed by LIKE. Also this condition evaluates strings using characters as defined by input character set.
      Example 1 :

      select first_name from employees where regexp_like (first_name,'^Walker|Ken|^Mr')

      First Name

      Walker, Mr. Kenneth (Ken)

      Example 2 : 

      SELECT first_name
FROM employees
WHERE REGEXP_LIKE (first_name, '^Ste(v|ph)en$');

      FIRST_NAME

      Steven

      Stephen

      Example 3 :

      SELECT last_name
FROM employees
WHERE REGEXP_LIKE (last_name, '([aeiou])1', 'i');

      LAST_NAME

      De Haan

      Greene

      Bloom

      Feeney

       

      • 0

    Leave an answer

    You must login to add an answer.

    Need An Account,