Postgres search using php

[ghjk]

I'm developing web page with php and postgres. There I want to search database. This is my query:

$sql="SELECT * FROM \"User\" WHERE \"UserName\" LIKE '%$search%';";

When I type "fernando" It gives all names including that name. But it didn't give names having "Fernando"(Capi tal letter).
Ex: Kez fenando, fernando,

not gives: Kenth Fernando

[bilibytes]

You have to insert consistent data in your database:

or all the names start with a captial leter,
or all the names are lowercased
or whatever way you like them to be.

then when you look for 'fernando' you will get all the records

if you want to case the name differently to show to your web users, then it should be done in the php side.

$name = ucords(strtolow er($row['name']));

hope you understand

[dlite922]

Never used postgres: It's case sensitive?

You won't have this problem with MySQL.


Dan

[Dormilich]

You won't have this problem with MySQL.

unless you use binary strings…

[Canabeez]

I'm developing web page with php and postgres. There I want to search database. This is my query:

$sql="SELECT * FROM \"User\" WHERE \"UserName\" LIKE '%$search%';";

When I type "fernando" It gives all names including that name. But it didn't give names having "Fernando"(Capi tal letter).
Ex: Kez fenando, fernando,

not gives: Kenth Fernando

Can't you use REGEX? Sorry, gave you the wrong link, that one goes to mySQL, here's what you need.

[ghjk]

Thanx all. This is working

$sql="SELECT * FROM \"User\" WHERE \"UserName\"  ~*  '%$search%';";