Is this one of those places where a HAVING clause is needed?
... HAVING YESNO = 0
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Lars Schwarz [mailto:[EMAIL PROTECTED]
> Sen
Hi,
Hope, a string constant can be searched against a column; Most of the
string function including find_in_set, allows us to display only the table
values and not the string constants passed.
Try it with 2 tables; or some userdefined functions.
Thanks
ViSolve DB Team.
- Original Message
Hi.
On Thu 2002-07-25 at 10:49:47 -0500, [EMAIL PROTECTED] wrote:
> Hi, I have a problem where the index for a SET column does not get used
> once I link in another table.
>
> The output to explain:
>
> mysql> explain select count(*) from NS_articles where
> find_in_set('approved', artFlags)
Hi.
On Thu, Dec 13, 2001 at 10:50:30AM +, [EMAIL PROTECTED] wrote:
> 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
>
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:/
mysql> create table gd_records(
-> id int unsigned auto_increment,
-> res_skills
set("skills1","skills2","skills3","skills4","skills5","skills6"),
-> res_skills_ma
set("skills_ma1","skills_ma2","skills_ma3","skills_ma4","skills_ma5","skills_ma6"),
-> primary key(id));
Query OK, 0 r
Can you provide your table description?
You have two set colums? One called res_skills and one called
res_skills_ma ?
Etienne
Wiliam Stephens wrote:
>
> Hi
>
> Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well,
> I'm using the following:
>
> ELECT * FROM gd_
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
Hi
I've got the following SQL statement for a MySQL database:
SELECT * FROM gd_records WHERE FIND_IN_SET('$value',$field)
What I want to know is how do I replace $value with a number of the
position of the SET field? Ugh, I'll try and explain this more clearly.
I've got the following
