Re: SQL Question about like

From: Michael Nolan <htfoot(at)gmail(dot)com>
To: "pgml(at)gmx(dot)de" <pgml(at)gmx(dot)de>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: SQL Question about like
Date: 2020-08-10 17:01:08
Message-ID: CAOzAquJJq-gD75j+VU=TJQ_mwEcuOYLOTPrvBNfFwvjP7qySEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The problem is your field is fixed length text, change it to varchar(100)
or text and it works without the wildcard at the end.
--
Mike Nolan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Israel Brewster 2020-08-10 17:10:00 Re: UUID or auto-increment
Previous Message Adrian Klaver 2020-08-10 16:58:51 Re: UUID or auto-increment