Searching for Dates in Non Standard Formats MySQL

[ctilley83]

Searching for Dates in Non Standard Formats MySQL

[Helveg]

Hi there! Take a look at the source code here:

nestjs-paginate/src/paginate.ts

Lines 331 to 342 in f85337d

	const condition: WherePredicateOperator = {
	operator: 'ilike',
	parameters: [alias, `:${property.column}`],
	}
	if (['postgres', 'cockroachdb'].includes(queryBuilder.connection.options.type)) {
	condition.parameters[0] = `CAST(${condition.parameters[0]} AS text)`
	}
	qb.orWhere(qb['createWhereConditionExpression'](condition), {
	[property.column]: `%${query.search}%`,
	})

We seem to apply the ilike operator. Since I don't know the specific MySQL feature you're talking about, maybe you can see how to implement this feature?