1 year ago

#329692

test-img

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

Accepted video resources