MySQL

like statment and upper / lower case

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2009

Posts: 144

Reputation: HITMANOF44th is an unknown quantity at this point

Solved Threads: 19

HITMANOF44th HITMANOF44th is offline

Offline

Junior Poster

like statment and upper / lower case

Apr 10th, 2009

i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ?

Help with Code Tags

MySQL Syntax (Toggle Plain Text)

$query = "SELECT * FROM `users` WHERE `$lookby` LIKE '%$lookfor%'";

Last edited by HITMANOF44th; Apr 10th, 2009 at 12:25 pm.

•

Join Date: Dec 2007

Posts: 195

Reputation: mwasif is an unknown quantity at this point

Solved Threads: 27

mwasif

Offline

Junior Poster

Re: like statment and upper / lower case

Apr 11th, 2009

What is the collation of $lookby? Did you alter table structure or upgraded MySQL?

•

Join Date: Jun 2008

Posts: 79

Reputation: varmadba is an unknown quantity at this point

Solved Threads: 8

varmadba

Offline

Junior Poster in Training

Re: like statment and upper / lower case

Apr 13th, 2009

Take a note all binary collation are case sensitive

:- Varma

We are Happy to inform launch of a new site with loads of database related information Site offers wide range of functionality Forums,Blogs,Articles,Editorials and much more
http://www.sqllibrarian.info/