What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

Questions by JohnMathew   answers by JohnMathew

Showing Answers 1 - 12 of 12 Answers

RajivPrasad

  • May 5th, 2007
 

The operator that is used for case-insensitive regular expression searches in POSTGRESQL is ~* and similarly there is another operator denoted as ~ in POSTGRESQL which is used for matching case-sensitive regular expression.
Let us see an example of both of these POSTGRESQL operator usages:
Example For case-insensitive regular expression searches in POSTGRESQL:
'exforsys' ~* '.*Exforsys.*'
Example for matching case sensitive regular expression in POSTGRESQL:
'exforsys' ~ '.*exforsys.*'

  Was this answer useful?  Yes

gobisankar

  • May 7th, 2010
 

Example for using ilike we can get it

SELECT city_name FROM cities WHERE city_name ilike '%chennai%';

this will print both CHENNAI and chennai

Regards,
Gobi S.

  Was this answer useful?  Yes

parth

  • Aug 15th, 2017
 

It is like search operator.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions