Learn how to achieve SQL LIKE functionality in MongoDB using $regex operator. Complete guide with case sensitivity options, performance tips, and practical examples for pattern matching.