[DimaShift]

hi...I need help!

when I want to look for a nick in the MySQL R41-4 database..
"SELECT * FROM `users` WHERE `user` = '%e' LIMIT 1"
when doing a scan, if there is a nick,in small letters ...
but on the basis there is not the word in small letters, only in big letters... then it appears in large letters...
how can I fix this problem?

[MEW273]

Sorry I don't quite understand your question, to clarify are you trying to return the nickname only if it is lower case (small letters)?

[wallee]

you can do something like this:

Код:

SELECT LOWER(*) FROM users WHERE user = '%e' LIMIT 1

this will return everything in lowercase

[DimaShift]

Quote:

Originally Posted by wallee you can do something like this: Код: SELECT LOWER(*) FROM users WHERE user = '%e' LIMIT 1 this will return everything in lowercase

my send error..

[11/25/17 04:31:58] [plugins/mysql] error #1064 while executing query "SELECT LOWER(*) FROM `users` WHERE `user` = '[MD]_Shift' LIMIT 1": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM `users` WHERE `user` = '[MD]_Shift' LIMIT 1' at line 1

[DimaShift]

Quote:

Originally Posted by MEW273 Sorry I don't quite understand your question, to clarify are you trying to return the nickname only if it is lower case (small letters)?

nick check, nick examples: SHIFT or Shift
then if it is saved in small letters and will be the first in the press, I will check nick: shift