How to select json array from mysql?

Question

I have such json array in MySql

[{  "to": "0xACA7A6819ebc5135D1Be4D9952C1219ad6a3182f", 
  "from": "0xF6b023e576E86067e9604ee31215873E4495C06f"}]

I need simple action, just get all array!

 // This not work
 SELECT deposit FROM users WHERE wallet = 0X...

can you please provide mysql version.? also datatype of column — Shanteshwar Inde, May 30 '19 at 06:56

Hugo · Answer 1 · 2019-05-30T06:54:02.743

0

Try using 'like' keyword.

ex :

"SELECT deposit FROM users WHERE wallet like '%0xACA7A6819ebc5135D1Be4D9952C1219ad6a3182f%';

statement above should able to select all the record where wallet column contain string above.

Note : add the percent sign indicate it's a wildcard search

edited May 30 '19 at 06:54

answered May 28 '19 at 09:50

Hugo

Not help = or like return the same result RowDataPacket { deposit: 'deposit' } – Руслан Миров May 28 '19 at 10:07
Sorry my mistake this not work SELECT ? FROM users WHERE wallet like ? need do this SELECT" + columnName + "FROM users WHERE wallet like ? – Руслан Миров May 28 '19 at 11:09
Hi @РусланМиров ,I have edited the answer again.To add percent sign to indicate wildcard search might help u to search out the record. – Hugo May 30 '19 at 06:55

1 Answers1