MySQL Problem! - Printable Version

MySQL Problem! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Problem! (/showthread.php?tid=645319)

MySQL Problem! - DimaShift - 25.11.2017

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?

Re: MySQL Problem! - MEW273 - 25.11.2017

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)?

Re: MySQL Problem! - wallee - 25.11.2017

you can do something like this:

Код:

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

this will return everything in lowercase

Re: MySQL Problem! - DimaShift - 25.11.2017

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

Re: MySQL Problem! - DimaShift - 25.11.2017

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