[Pavel Chysky]

Hi all,

I am a new user of SQLyog, it is great tool.

But I want interpellate for GUI quick filtering functionality, it is a very essential feature.

Writing something like SELECt .. WHERE .. is quite hairy.

But WHERE clause must be simply editable, options Field=value, Field>value,.. only are too few.

Very important is especially Field LIKE %value% etc.

e.g. I have table, thousands records. I want find record where Name=Mary, but I see records with other names only, because limit=e.g.50.

Right click at field “Name” with value John, option “QuickFilter” -> “Field like %value%”.

Into field “Condition” somewhere in form appears text “Name LIKE '%John%'”. I must edit this text – change to “Name LIKE '%Mary%'” (or “Name LIKE '%Mary%' AND Age > 16” is better 😛 ), and then click “apply filter”.

Many thanx

Pavel

[Author]

Posts