Query Search database for text string

Question

I try adapting other question asked here about this matter but seems to complicated to remake. So I'm asking again, how do I search a database for a number, I have 'database' with column id and number and I want to search for number 655985025897377800. This might be simple and my brain bluescreens again.

id number
1 655985025897377792
2 655985025897377800
3 655985025897377900
4 655985025897377234
5 655985025897377213
6 655985025897377122

use where number='655985025897377792' or use number like '%655985025897377792%' — Abhishek Sharma
– Abhishek Sharma, Commented Oct 19, 2015 at 11:10
like I said it was simple but my brain blue screened :) SELECT row FROM database WHERE row = ? . Thanks — Alex _TNT
– Alex _TNT, Commented Oct 19, 2015 at 11:14
SELECT * FROM database WHERE number LIKE '%655985025897377800%' — turbopipp
– turbopipp, Commented Oct 19, 2015 at 12:00

Abhishek Sharma · Accepted Answer · 2015-10-19 11:15:14Z

2

Use where with =

where number='655985025897377792'

Use where with like

use number like '%655985025897377792%'

answered Oct 19, 2015 at 11:15

Abhishek Sharma

6,6241 gold badge17 silver badges20 bronze badges

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

1 Comment

Alex _TNT Over a year ago

I'll accept this as answer but I have to wait 4 more minutes. Cheers and Thanks again

Collectives™ on Stack Overflow

Query Search database for text string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related