Find Toyota listings, regardless of case

Search listings need to be case-insensitive: a buyer searching "toyota" should find titles written as "Toyota", "TOYOTA", or anything in between.

Return id, title, and price for every listing whose title mentions Toyota in any casing.

Schema

▸listings

id	INT
title	TEXT
price	NUMERIC

Example input

▸listings

↑ Read the question

Keep going

More text questions

easyClean up messy product names99 Speedmart · textFree→easyClean up messy size codesPadini · textFree→easyFind products from a specific brandLazada · textFree→easyMerchants on personal email domainsFoodpanda · textFree→

All text and pattern matching questions →Learn text and pattern matching first →

Company names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.