1

Topic: As it is possible to fulfill delete query

Respected  help, as it is possible to fulfill such request.
There is table FieldName, FieldValue, SubmissionId
formId, 3, 49
submit, To Send, 49
data, 30.09.17, 49
note2, , 49
yesno2, There is a tolerance, 49
fio, The test the test 3, 49
number2, 113, 49
order2, Separation of purulent surgery, 49
formId, 3, 48
submit, To Send, 48
data, 26.09.17, 48
note2, , 48
yesno2, There is a tolerance, 48
fio, The test the test 2, 48
number2, 123, 48
order2, Separation of purulent surgery , 48
formId, 3 , 47
order2, Separation of purulent surgery , 47
number2, 111, 47
fio, The test the test the test, 47
yesno2, There is a tolerance, 47
note2, , 47
data, 24.09.17, 47
submit, To Send, 47
As it is possible to implement removal of the data across the field data if this field less than current Date

2

Re: As it is possible to fulfill delete query

The field data has text type

3

Re: As it is possible to fulfill delete query

folkemon wrote:

the field data has text type

to Transform to date-time (field type or in request). Or in request in string type in a format "YYYY-MM-DD". Both that, and another allows to do direct comparing.

4

Re: As it is possible to fulfill delete query

I wrote such request

DELETE FROM ` oyj15_rsform_submission_values`
WHERE FieldName ='data ', ` FieldValue ` <STR_TO_DATE (now (), ' %Y- % M - % d ')

But then it turns out that deletes all data except the date, and it would be necessary to me that it except date left both fio and number2 and other

5

Re: As it is possible to fulfill delete query

folkemon wrote:

I wrote such request

Such request generally should lead Syntax Error.