find text on server without the like

[expired user #9854]'s profile image [expired user #9854] posted 8 years ago in General Permalink

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?

ansgar's profile image ansgar posted 8 years ago Permalink

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?

[expired user #9854]'s profile image [expired user #9854] posted 8 years ago Permalink

yes this will help a lot :-)

Code modification/commit 76e038c from ansgarbecker, 8 years ago, revision 5083
Support wildcard options in "Find text on server" dialog in a new drop down box, to provide a possibility to find exact matches. See http://www.heidisql.com/forum.php?t=21388
ansgar's profile image ansgar posted 8 years ago Permalink

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

ansgar's profile image ansgar posted 8 years ago Permalink

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.