using a column value in IN() in a join condition.

ite a number of Join types, all to no avail. any help would be great. ken easson justken.net [EMAIL PROTECTED] justken web programming and technical support. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

best way to optimize a table with many to few relationship.

ories: si-fi, figure, abstract, robots, boys product: pad, case, appliance item: robot-girl categories: si-fi, figure, abstract, robots, girls product: pad, case, appliance item: dragonship categories: si-fi, animals, fantasy, space product: pad, case SELECT QUERY MYSQL ken easson justken.net

best way to optimize a table with many to few relationship.

EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ken easson justken.net [EMAIL PROTECTED] justken web programming and technical support. - Be

Re: how do i retrieve distinct rows using IN

> >What is the problem, the business problem you are trying to solve? or what do >you need from your data? i think you are just querieng for the wrong >information .. but since i dont know what you are trying to do, i cant say >more right now. >Id need more information.. &

how do i retrieve distinct rows using IN

eate a hash $catNum{partB} = 2, and then for each item returned, check the hash and multiple the price by it's results. This seems extremely slow if my problem can be solved in sql alone. can anyone help? ken easson justken.net [EMAIL PROTECTED] justken web programming and technical support.

preventing duplicate records when using WHERE foo IN syntax

key, but i don't know how to set up the IN statement for a double part: WHERE concat (component, '-', catNum) IN ($system) can anyone help me with a solution. thanks. ken easson justken.net [EMAIL PROTECTED] justken web programming and technical support. -

including text or blob in large table that is freaquently searched.

s. and find that it doesn't always use the indexes i create to assist in the searches. i'm designing for around 15,000 records in this table. where details can be several lines of text (on average 150 words). ken easson justken.net [EMAIL PROTECTED]

RE: merge tables using sql to find table names

> >Does your master table have a list of table names and the table's >characteristics? How is the search called? currently i have a master table called "files", the primary key is id and the data tables are called filedata1 filedata2, etc. where 1 and 2 correspond to the file id. Each of the f