[prev] [thread] [next] [lurker] [Date index for 2007/03/20]
Smylers writes:
> MySQL has a couple of functions for extracting a substring from
> a string. The one in which you specify an index is called
> Substring(). The one in which instead of an index you specify
> a delimiter is called ... wait for it ... Substring_Index().
Ah, yes.
MySQL: The DBMS Designed To Make Your PHP Programmers Feel At Home.
On the assumption that this is a good moment for MySQL-related hate,
here's one that bit us earlier today:
mysql> select id, label, concat('[', label, ']') as literal
mysql> from tag where label = 'gpl' \G
*************************** 1. row ***************************
id: 255649
label: gpl
literal: [gpl ]
For the record, the column is of type `varchar(255) character set utf8
collate utf8_bin` -- not `char(N)`, and certainly not `char(4)`.
I don't know how better I can tell MySQL that I really really care about
equality of the actual values I'm trying to store in this column.
I'm prepared to believe that this is merely a bug in our particular
point-release of the server, rather than a fundamental design flaw, but
that doesn't stop it being incredibly hateful: if I'm looking for
something equal to an exemplar, then, no, something vaguely similar is
_not_ sufficient.
--
Aaron Crane
Generated at 14:43 on 31 Mar 2007 by mariachi 0.52