PDA

View Full Version : LIKE statment in postgresql

dblinux
06-10-02, 09:55
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...
eperich
06-11-02, 05:58
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
rycamor
07-11-02, 23:10
ILIKE is also available on PostgreSQL (at least, later versions):

SELECT * FROM Computers WHERE Description ILIKE 'HZLMP*