Re: Get hash of MySQL row

> On Wed, Feb 06, 2002 at 01:57:21PM +0000, Wiliam Stephens wrote: >> Hi >> >> I want to retrieve a row of MySQL data using Perl and DBI, so I do it >> like this: >> >> [code] >> my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id

Get hash of MySQL row

here's a better way to retrieve the information from MySQL? -- Wiliam Stephens <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

find_in_set )>0;

Hi I'm using the partial MySQL query: FIND_IN_SET('Specific Locations',res_places)>0; AND FIND_IN_SET('Wales',res_places_sl)>0; And I was just wondering why use the ">0;". Why are they needed? What does this tell MySQL? Thanks Wiliam Steph

matching an option from SET list

ay of going about what I'm trying to do? I don't want to use FIND_IN_SET because I won't always know the SET option name to pass to FIND_IN_SET. Thanks for your help. Wiliam Stephens Web Developer http://www.fbagroup.co.uk --

Re: find_in_set syntax

At 17:40 11/12/01, you wrote: >Can you provide your table description? > >You have two set colums? One called res_skills and one called >res_skills_ma ? Yeah, Both are SET columns. Wil - Before posting, please check: http:/

Re: Re: find_in_set syntax

At 17:23 11/12/01, you wrote: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in your message: > >database,sql,query,table > >If you just reply to this message, and include the

find_in_set syntax

s even if the second statement is true or not? Why is this? Is this a major bug or is there a problem with my query? Thanks Wiliam Stephens Web Developer http://www.fbagroup.co.uk - Before posting, please check: http://

Re: Index of SET Field

`,': > > mysql> SELECT FIND_IN_SET('b','a,b,c,d'); > -> 2 >= > >I don't know what exactly you're trying to acheive, but I'm pretty sure >FIND_IN_SET is not what you are looking for. > >Can you give tab

Index of SET Field

Hi How can I create an index of a SET field so that a FIND_IN_SET can search for a column number rather than name? Is this even possible in MySQL? It might seem like a bug? Thanks. Wiliam Stephens Web Developer http://www.fbagroup.co.uk

Re: FIND_IN_SET

position number - 1 (or is it 0 like perl?). Thanks for any information you can give me. Rgds Wiliam Stephens Web Developer http://www.fbagroup.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the