New Feature Suggestion

I wish that the text editor had a search & replace utility; it would definitely speed up my work.

- j

The query editor has that - but I guess you mean the grid-text editor?

I have a big database (almost 600 mb).

So, it would be easier to make the server find and replace unwanted text.

Yet, when I access data in a table, that particular text editor has various features, but not a search and replace.

- j

You should help yourself with SQL:

UPDATE mytable SET col=REPLACE(col, from_str, to_str)

Thanks, but that wide-sweeping UPDATE command would miss slightly-different occurrences of the string needing replacement.

It would also replace those instances where the string being sought was, actually, part of an acceptable larger string. Or, when taken into proper context, was also acceptable. In these cases, I would not want to replace the string. For example, I do not want porn posted at my site. So, I would likely want to remove database lines which said something like: "You have permission to post porn here." To locate this type of string, I might search for "permission to".

Yet, I would probably not want to remove strings which said: "You do not have permission to post porn here." - despite that the search string "permission to" was present.

Similarly, I would probably not want to remove strings which were part of an interview and, so, were quotes - regardless of the search string being present.

So, prior to replacing, a visual check would be prudent.

So, this is when a dedicated search facility, in the text editor, would be handy.

Along a similar vein, a dedicated search facility would be handy where the data comprised of numerous paragraphs and the small string, which was being sought, was located somewhere among those paragraphs. So, it would be handy if the search facility highlighted all occurrences being sought.

- j

Here's another idea: How about incorporating the highlight feature, above, into the data tab's filter, too?

- j

It would be interesting to implement shortcuts to the most used in the syntax editor.

Example 1:
When you type sf + space appear "SELECT * FROM".

Example 2:
When you type ii + space appear "INSERT INTO () VALUES ()".

thankful