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]
paul created
reference:users_users [2018/11/14 10:45] (current)
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 (external edit)