selec using first letter
hi all, i have this table filled with names. Does anybody know how I can write a select statement which selects all names starting with a certain letter in the alphabet or a strane sign like [0...9 )(*[EMAIL PROTECTED]|?/,.] ??? any tips or help are most welcome! Regards Wilbert Enserink -- mysql,select - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
copying a row
Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
copying a row
Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
random select 1 record
Hi all, anyone knows a good method to retrieve 1 random selevted record out of thouseands? right now I'm using select ID from table ORDER BY rand() LIMIT 1 however, this seems like a very slow method, like mysql first organizes a few thousand records in a random 1 and only returns 1 Any help would be great! thx. Wilbert --query, mysql--- - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select using 2 left joins
Hi Jed, you aree totally right. The statement I typed should indeed be: WHERE tableName.manufacturersID=12 Meaning I got the ambiguity error. thx for the tip, Wilbert - Original Message - From: Jed Verity [EMAIL PROTECTED] To: Wilbert Enserink [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 02, 2002 6:38 PM Subject: Re: select using 2 left joins I'm a little surprised that MySQL isn't giving you an error on the ambiguity of manufacturersID=12. What happens if you specify tableName.manufacturersID=12? HTH, Jed On the threshold of genius, Wilbert Enserink wrote: Hi all, I'm having troubles with a good selection statement in my query. I have three tables: tableAds, tableProducts and tableManufacturer. They all have unique ID's defined. In the tableProducts there is a column named manufacturerID. So I know which product was made by which manufacturer. In the tableAds I have a column ProductsID so I know what Product is advertised. Now I want to find all the adsvertisments of products which are made by a specific manufacturer. I'm trying a query like: SELECT * FROM tableAds LEFT JOIN tableProducts ON (tableProducts.productsID=tableAds.productsID) LEFT JOIN tableManufacturers ON (tableManufacturers.manufacturersID=tableProducts.manufacturersID) WHERE manufacturersID=12 However this query returns all advertisments in the tableAds and not the Ads wirth manufacturer number 12 involved. Anybody knows how to improve this query? Any help would be much appreciated. thx in advance. Wilbert Enserink - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql error
Hi all, has anybody ever seen this? And knows what it means? thx. You have an error in your SQL syntax near 's self-supporting ribbed form was probably not strong enough to render the desig' at line 1 regards Wilbert mysql error / query - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
exclude columns in query
Hi all, is it possible to exclude columns in a query? something like select * from table except columnname ?? regards WIlbert mysql. - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql query for next unique ID
Hi all, Does anybody know if there is a function to retrieve the next unique ID number for a record to be made in the future? thx. Wilbert mysql query for next unique ID - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'show next' and show 'previous' buttons
Hi all is it possible to perform a query which points out a record with a unique ID and then return the previous record and the next record also? I want to make 'show next' and show 'previous' buttons on my websitepage showing the contents of the current record, and I'm looking for a clever way to do this. thx for any tips. regards Wilbert Enserink - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php