This is a terribly slow approach, but it works. WHERE upper(USERNAME) = '#uCase(ername)#' You can view EDUCBA’s recommended articles for more information.I don’t know about MySQL, but in Oracle you can force the db column value to lower- or upper-case for comparison, and do likewise from the server-side aspect.įor example, if this were ColdFusion (and I’m intentionally omitting parameterized query variables for brevity): We hope that this EDUCBA information on “MySQL CASE Statement” was beneficial to you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |