How to find record having % as part of data.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
I am having problem retrieving data with % in the value. I tried a lot
but so far i have no luck.

for example i have first name = 'abc', middle name = 'pq%', last name
= '123'

I want to list all the entries that ends with %. Because those are
wrong entries and i want to remove % from the middle name and retain
'pq' only.

Any help is very much appreciated.

Thanks
Biswa.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux