ience with
mySQL. If it's not too much trouble, could someone give me a bit more help
on how to do that please?
Ed.
no, those won't match based on just the datatype change.. you will
have to define a user defined function to do those comparisons.
On 6/14/07, Edward Quick <[
defined function to do those comparisons.
On 6/14/07, Edward Quick <[EMAIL PROTECTED]> wrote:
Thanks, that's interesting. Actually the uc.ID column is still type
tinyint
as it holds only one number, but are you saying if I change this to
varchar
my query will work e.g. 15 = 15:17 wo
will work fine. If it's an integer type, you are going to have a
problem because you have bt.category_ID holding things which can't be
represented as integers and will therefore never match. IF both
column type are being changed here, your query will work fine as is.
- michael dykman
On
Hi,
I have the following mySQL query in my script which has been working fine
but due to a recent change, I had to modify one of the columns,
bt.category_ID. This used to be defined as tinyint(3) but I've changed that
now to varchar(20) as it needs to hold values such as 15, or 74:79 or
43:56
