You can change your query to something like: <somequery> ... WHERE CONCAT(CAST(anumber as CHAR), aname) LIKE '12SomeString'
Using the CAST function seems to trick CONCAT into thinking that it only received CHARs. Not that elegant but it might be a little more efficient that using LOWER() or UPPER(). On Mon, 20 Oct 2003 18:05:58 +0200 (CEST), Thomas Spahni spoke thusly about RE: I need the opposite of BINARY: > Simon > > you missed this from the manual: > > <quote> > If you want to convert a number to a string explicitly, pass it as the > argument to `CONCAT()'. > > If a string function is given a binary string as an argument, the > resulting string is also a binary string. A number converted to a > string is treated as a binary string. This only affects comparisons. > > Normally, if any expression in a string comparison is case-sensitive, > the comparison is performed in case-sensitive fashion. > <unquote> > > It is well documented. My question was about how I could change this, > because I want to perform a comparison in a NON-case-sensitive fashion. > > Thomas Spahni > > > On Mon, 20 Oct 2003, Simon Green wrote: > >> CONCAT turns every this in to a string then puts them together? >> LIKE is not case sensitive with string? >> When is this turned in to BINARY? >> >> What have I missed please >> Simon >> >> -----Original Message----- >> From: Thomas Spahni [mailto:[EMAIL PROTECTED] >> Sent: 20 October 2003 15:38 >> To: [EMAIL PROTECTED] >> Subject: I need the opposite of BINARY >> >> >> Hi, >> >> I do the following: >> >> <somequery> ... WHERE CONCAT(anumber, aname) LIKE '12SomeString' >> >> As explained in the manual this is treated as a BINARY comparison i.e. >> case of the letters matter. I need a case independent comparison here. Is >> there a way to get the usual behaviour of LIKE in this case? (besides >> translating all characters to LOWER which is IMHO no elegant solution). >> >> TIA >> Thomas Spahni --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
