Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Italy
    Posts
    36

    Unanswered: LIKE statment in postgresql

    I've got to have a query using the LIKE operator... What is the Jolly character to run the query correctly?

    exaple:
    SELECT * FROM Computers WHERE Description LIKE 'HZLMP*'

    and...

    can i remove the case sensitive option in postgreSQL???

    thanks...

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Search

    You will need thsi search operator


    SELECT * FROM TABLE WHERE name~*"HJSDHK";

    this is case insensitive and you will get all rows where this string is in
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    May 2002
    Location
    Florida, USA
    Posts
    49
    ILIKE is also available on PostgreSQL (at least, later versions):

    SELECT * FROM Computers WHERE Description ILIKE 'HZLMP*

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •