At 15:21 +0200 1/18/03, Octavian Rasnita wrote:
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?
Depends on the context. If you issue a
SHOW COLUMNS FROM mytable LIKE 'my_col'
statement, then 'my_col' will match my_col, but also myxcol, my0col, etc.
You need to write it like
SHOW COLUMNS FROM mytable LIKE 'my\_col'
to match my_col *only*.
But in the context of other statements that do not interpret a name
as a pattern, _ won't be taken as a wildcard.
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
