find text on server without the like

Trigun posted 2 years ago in General


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?

ansgar posted 2 years ago

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?

Trigun posted 2 years ago

yes this will help a lot :-)

ansgar posted 2 years ago

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

ansgar posted 2 years ago

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.

Please login to leave a reply, or register at first.