User Tools

Site Tools


reference:users_users

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
reference:users_users [2012/03/20 14:56] – created paulreference:users_users [2018/11/14 10:45] (current) – external edit 127.0.0.1
Line 6: Line 6:
   * username - this is the text name of the user   * username - this is the text name of the user
  
-**username** is case insensitive and is indexed in lower case, so to take advantage of the index use something like ''SELECT * FROM users.users WHERE LOWER(username)='fred'''+**username** is case insensitive and is indexed in lower case, so to take advantage of the index use something like ''SELECT * FROM users.users WHERE LOWER(username)='fred' ''
reference/users_users.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1