How to do an equality comparison in a MySQL WHERE clause?

Question

I have this piece of code

$player = mysql_query("SELECT * FROM `Player` WHERE `LogOn` ? `GAME`")
or die(mysql_error());

My issue is where I placed question mark, I need to have it so it would be Login is equal to GAME. I probably would of found the answer by searching the web, but I lack the English words.

Possible duplicate of [Sql where clause not working](http://stackoverflow.com/questions/27202157/sql-where-clause-not-working) — John_West, Mar 02 '16 at 00:31

score 1 · Accepted Answer · answered Mar 01 '16 at 22:44

1

Here's what you need:

SELECT * FROM `Player` WHERE `LogOn` = 'GAME'

You can use upper() for case insensitive check:

SELECT * FROM `Player` WHERE upper(LogOn) = 'GAME'

answered Mar 01 '16 at 22:44

Darshan Mehta

30,102
11
68
102

score 0 · Answer 2 · answered Mar 01 '16 at 22:44

0

Use = to check for string equality.

SELECT * FROM `Player` WHERE `LogOn` = 'GAME'

Please note ' for string quotes in mysql.

answered Mar 01 '16 at 22:44

bolav

6,938
2
18
42

How to do an equality comparison in a MySQL WHERE clause?

2 Answers2