943,977 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Marked Solved
  • Views: 1700
  • MySQL RSS
Apr 10th, 2009
0

like statment and upper / lower case

Expand Post »
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 ?


MySQL Syntax (Toggle Plain Text)
  1. $query = "SELECT * FROM `users` WHERE `$lookby` LIKE '%$lookfor%'";
Last edited by HITMANOF44th; Apr 10th, 2009 at 12:25 pm.
Reputation Points: 24
Solved Threads: 33
Posting Whiz in Training
HITMANOF44th is offline Offline
283 posts
since Apr 2009
Apr 11th, 2009
0

Re: like statment and upper / lower case

What is the collation of $lookby? Did you alter table structure or upgraded MySQL?
Reputation Points: 29
Solved Threads: 47
Posting Whiz
mwasif is offline Offline
312 posts
since Dec 2007
Apr 13th, 2009
0

Re: like statment and upper / lower case

Take a note all binary collation are case sensitive
Reputation Points: 22
Solved Threads: 9
Junior Poster in Training
varmadba is offline Offline
83 posts
since Jun 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: size of database
Next Thread in MySQL Forum Timeline: Sort and display first 3 results





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC