I have an input like 0.05841. But in my database, I have a similar value to the given value like (0.05842,0.05857). How do I fetch related detail from the database in PHP?

Any answer ?

CodePudding user response：

Please Use This Query

SELECT * FROM TableName
WHERE ColumnName LIKE '%YourVariableValue%';

CodePudding user response：

for like query you can match the value to the first four characters.if you give the exact value then you can not match the value