Replacing "LIKE" with "=" - Mailing list pgsql-sql

From sharmad@goatelecom.com
Subject Replacing "LIKE" with "="
Date
Msg-id 3c10405a.6b0.0@punweb01
Whole thread Raw
Responses Re: Replacing "LIKE" with "="
List pgsql-sql
Can I replace a query statement having a "LIKE" with a statement having "="
still getting the same functionality

Like for ex:-
SELECT * from teble_name WHERE name LIKE "%name%";

Keeping in mind the output of the query i want to replace this query with a
statement having "=" and no more "LIKE"

TIA
-Sharmad


pgsql-sql by date:

Previous
From: "Ligia Pimentel"
Date:
Subject: How to rename a database?
Next
From: mcornell@spamcop.net (mcornell)
Date:
Subject: DISCTINCT and literals - Unable to identify an ordering operator