I would like to query a database which is MySQL 5.
Let's say database name is db
and the table name is table
and the column name is column
and that column is a text
containing the following for example:
aksksksksjsjk&ct=100&lor=10
aksksksksjsjk&ct=1001001001001001&lor=10
So i would like to query that table and grep only where ct
start with number 1
and it's 16
numbers.
I tried with SELECT column FROM db.table WHERE column LIKE '%ct=1%'
so it's gonna grep where ct
start with number 1
so kindly try to help me to proceed with select ct
when start with number 1
and contain 16 numbers