The client has made the following changes to the job.
Bidding period ended early.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
Many databases allow case-insensitive pattern matching expression ILIKE, like
string ILIKE pattern
string NOT ILIKE pattern
Some databases, like MySQL, only has the case-sensitive expression LIKE, but does not support ILIKE.
You need to write a function in Java that will take a SQL statement as input and convert all ILIKE expressions into equivalent expressions with LIKE. Output will be something like:
UPPER(string) LIKE UPPER(pattern)
Here both string and pattern could be any string expression.
Please note that SQL keywords like ILIKE, LIKE, NOT, UPPER, etc are not case sensitive. I'm using capitalized forms for highlighting.
Sign in or Register to see more