Problem Using To_days Function

[peterlaursen]

I am afraid I do not understand this

“When I copy/paste the sentence “TO_DAYS(NOW()) – TO_DAYS(database.table.entdate) > 365″ in the filter column”

Where is that 'filter column'? in SQLyog?

I also do not understand

1) where you use PHP and where you use SQLyog

2) what works in SQLyog 4 (or 5) and not in 6?

A few screenshots may tell more than words!

[orionis]

>”When I copy/paste the sentence “TO_DAYS(NOW()) – TO_DAYS(database.table.entdate) > 365″ in the filter column”

>Where is that 'filter column'? in SQLyog?

yes, it's the “filtre” column in the “auth.hades” table, that is used by the cleaning program (see attached picture).

>I also do not understand

>1) where you use PHP and where you use SQLyog

The cleaning program is written in PhP and the cleaned databases have been created and are managed by SQLYog.

>2) what works in SQLyog 4 (or 5) and not in 6?

In versions 4 and 5, I can save the value “TO_DAYS(NOW()) – TO_DAYS(database.table.entdate) > 365” in the 'filtre' column, which cannot be made with version 6.

>A few screenshots may tell more than words!

Here it is :

[attachment=741:sqlyog1.jpg]

Hope it will be clearer for you! 🙂

[peterlaursen]

Now I think I understand.

You simply want to save this SQL snippet as a literal string?

Please try to enclose the string in `backquotes`!

Alternativley disable 'smart keywords and functions' in preferences.

I think SQLyog her attempts to evaluate as a function, refer to

http://webyog.com/faq/8_116_en.html

Please reply back if that was the issue!

[orionis]

>You simply want to save this SQL snippet as a literal string?

Yep 😀

>Please try to enclose the string in `backquotes`!

I already found this trick, but I thought there might be something else 'cleaner'!

>Alternativley disable 'smart keywords and functions' in preferences.

THAT'S IT! 🙄 It works, thank you very much for your help!

Fabrice

[Author]

Posts