findByTenantIdAndNameContaining

@Query(value = "SELECT c FROM Contact c WHERE c.tenantId = :tenantId AND c.deletedAt IS NULL AND LOWER(c.name) LIKE LOWER(CONCAT('%', :name, '%'))")
abstract fun findByTenantIdAndNameContaining(tenantId: String, name: String): List<Contact>(source)