Could someone please tell me the SQL script for searching for all names in a table with exactly 8 characters long?
WHERE length(foo) = 8
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."
U can use
select * from tablename where length(name) = 8 ;