Replacing "LIKE" with "="

From: sharmad(at)goatelecom(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Replacing "LIKE" with "="
Date: 2001-12-07 03:46:50
Message-ID: 3c10405a.6b0.0@punweb01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Melisa 2001-12-07 06:05:03 anyone can help?
Previous Message Stephan Szabo 2001-12-07 02:41:09 Re: [SQL] how to change the type