Add support for case-insensitive search

[MaryammAli]

- Description: Add search improvements for user and course queries.
- Path: `BackendAcademy/src/search/`

[Kenisank]

Hi maintainer, I would like to solve this issue

[Kenisank]

Hi maintainer, I would like to solve this issue

[Killerjunior]

Hi maintainer, I have read and understood the issue requirements and checked the necessary documentation. I’m confident I can work on this task effectively and deliver a proper solution.

[whitezaddy]

I have experience for this and have reviewed the code; I can submit a PR within 24hrs.

[jesutobaadedejidev]

I would like to work on this issue. Do assign it to me.

[gloskull]

Hello, I have 4 years of experience delivering solutions for projects like this, covering backend, frontend, and smart contract development. After carefully reviewing your requirements, I have a clear understanding of the task and am confident in my ability to deliver a clean, efficient, and thoroughly tested solution on time. I prioritize code quality, maintainability, and industry best practices throughout the development process. My PR will be submitted in under 10hours.

[oscar2004JT]

I have experience developing backend applications with Laravel, PHP, and PostgreSQL. For this issue, I would review the current search implementation and update it to perform case-insensitive searches while maintaining performance and existing functionality. I can submit a pull request after reviewing the codebase.

[faramir07]

I'm a Full Stack Developer with hands-on experience building backend systems using NestJS, Node.js, TypeScript, TypeORM, and PostgreSQL. I've developed production REST APIs, business logic, and database architectures, and I'm comfortable working with modular NestJS applications.

I understand this task involves improving the search functionality for users and courses. My approach is to review the existing search module, understand the current query implementation, optimize or extend the search logic while keeping the codebase consistent, validate the behavior through testing, and submit a clean PR following the project's contribution guidelines.