CODEWITHSUNDEEP
mysqlsql
Sireini
Sireini

Reputation: 4262

Select specific row from mysql table based on a column value

How do I select an specific row from mysql table?

This is my table: enter image description here

I want to select on a specific Token value, so what I tried is this:

SELECT * FROM Oefeningen WHERE Token = ('a6rqc')

But that returns me nothing, could somebody help me out on this?

Upvotes: 0

Views: 115

Answers (1)

Henry
Henry

Reputation: 1686

You may have a trailing or leading space. I.e. the value might actually be token=' a6rqc' or it might be token='a6rqc '. If you use %, you will be able to wildcard match, i.e. token like '%a6rqc%'

Upvotes: 1

Related Questions