Well the link provided isn't really about what I originally asked about. I
have not come across a SQL implementation (Postgres, MySQL, or MSSQL are
the ones I have experience in) where LIKE was "by default" case sensitive
with wildcards. That being said, I'm not the type to based my assertions
on
Thanks for the followup.
Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com
"I used to be with it, but then they changed what it was. Now, what I'm with
isn't it, and what's it seems we
function extended rlike;
OK
str rlike regexp - Returns true if str matches regexp and false otherwise
Synonyms: regexp
Example:
> SELECT 'fb' rlike '.*' FROM src LIMIT 1;
true
Time taken: 0.081 seconds
hive>
On 5/14/12, Keith Wiley wrote:
> On Apr 4, 2012, at 0
On Apr 4, 2012, at 06:40 , John Omernik wrote:
> I think the like statement should be changed to be case-insensitive to match
> it's function in other DBMS Thoughts?
Out of curiosity, was there any activity on this issue? I see John's original
post in the archives (~5
I did a test today:
select * from table where 'hello' like '%el%' limit 10;
I got 10 rows from my table
select * from table where 'HELLO' like '%el%' limit 10;
I got 0 rows from the same table.
Based on this, it would appear the like statement is
