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

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

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

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

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

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

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]

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

'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