modify value returned by SELECT with MySQL / PHP

Question

I want do such as this:

$username0 = $_POST["nkn"];
$username1 = strtoupper($username0);
$query = "SELECT username FROM users WHERE strtoupper(username) = '".$username1."'";

What's the right way to do this? Thanks.

use a case insensitive collation where you don't need any index killing functions. — juergen d
– juergen d, Commented Jun 21, 2013 at 13:13

Code Lღver · Accepted Answer · 2013-06-21 13:15:11Z

2

Use the below code:

$query = "SELECT username FROM users WHERE UPPER(username) = '".$username1."'";

In mysql the is the function UPPER() to convert the string in upper case.

answered Jun 21, 2013 at 13:15

Code Lღver

15.6k16 gold badges61 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1