CODEWITHSUNDEEP
mysqlsqluuid
Mr Kushy
Mr Kushy

Reputation: 43

Unable to select row where uuid = (number)

So i'm trying to lookup a uuid in my database but when i try to select it it gives me this error 

SELECT (`udid`, 1, 100) FROM `payments` 
WHERE `udid` = 584BA8D699204951B0B4C1591728E88E LIMIT 0, 25

1241 - Operand should contain 1 column(s)

ive tried making the limit 100 chars but as u can see same error

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
udid VARCHAR(50) NOT NULL,
paid BOOLEAN

Upvotes: 0

Views: 1664

Answers (1)

Alex Hodges
Alex Hodges

Reputation: 607

This should work:

SELECT `udid`, 1, 100 FROM `payments` WHERE `udid` = "584BA8D699204951B0B4C1591728E88E" LIMIT 0, 25

Removing the '(' ')' from around 'udid, 1, 100' was the fix, however you also needed to quote your strings.

Upvotes: 1

Related Questions