• Sign In
  1. Messages

case insensitive LIKE search in postgres

LabKey Support Forum (Inactive)

View Message

view list print
case insensitive LIKE search in postgres jeckels  2011-07-27 15:49
Status: Closed
 
Hi Ben,

You should be able to use LOWER():

SELECT * FROM MyTable WHERE LOWER(Column1) LIKE '%myvalue%'

Thanks,
Josh