Column type question ?

Hi ALL, I have an application that reads files converts them and then inserts them into a database. It has 2 columns that I need help with. First is the OFFSET column - this stores the datafile offset .. In C it is a UNSIGNED LONG and looks like : 0x2528 the second colun is a CRC for the f

Re: Column type question ?

thanks ;) On Fri, 03 Dec 2004 13:18:53 +0100, Roger Baklund <[EMAIL PROTECTED]> wrote: > TAG wrote: > > I have an application that reads files converts them and then inserts > > them into a database. It has 2 columns that I need help with. > > > > First is th

select question

HI, I need to do a select query that can do the following: select * from table where col1 like hex("somestring"); My problem is HOW do I get the % in there??? The Mysql Server is 4.0.4 and the table has a blob field with hex stored in it Thanks Tonino