1 year ago
#329692
Aanand Ingle
How to use where clause to get the output on the basis of the length of Character's in it
So the thing is that I have the following question: Display the column Brand from the table clothing where length(Brand)=10.
So I used the query: select Brand from clothing where length(Brand)=10; This gives me the out put as an empty set, so I checked my table to see if it was actually supposed to give an empty set and the answer was no. So if anyone would be able to tell what's going wrong then that would be of great help The images for the table and the input I tried are given below. Table image and the input I gave
mysql
where-clause
string-length
0 Answers
Your Answer