find text on server without the like

hello

is possible to search something without the like %text% ? i need to search for a number on the db like "10" but when i use the find function i get all the result with "10" because the query is like "where col like %10%" instead "where col = 10" is possible to force this kind of search? a search for the exact match?

Not yet with the text search dialog. But I could add a radio button below the "Case sensitive" checkbox, asking for

• Left and right wildcard
• Exact match
• Left wildcard
• Right wildcard

Does that make sense?

yes this will help a lot :-)

Done in r5083. Please update HeidiSQL and report back if that works for you.

One thing: Note that if you want to search float numbers, you need to enter these in your system locale, for example "1,23" on a german Windows.