But I know that the _ character is used as a wildcard for any single character. wouldn't it be considered it as a wild card when using it in a column name?
Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Keith C. Ivey" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Cc: "Octavian Rasnita" <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 8:31 PM Subject: Re: Column names On 17 Jan 2003, at 16:40, Octavian Rasnita wrote: > In MySQL I know that I need to put the column names between `` in some > cases if they contain a % or an _ sign in it. Please tell me what sign > can I use to link 2 words in a column without needing to include that > column name between ``. > > Can I use a - (dash) sign, or it might be considered in some cases a > minus operator? You shouldn't need `` around column names that contain _. Underscore is pretty standard for separating words in a name. With dash, you'd have to use ``, because - is the minus operator. [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- 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