Re: How to select records from columns with where default =
"Robert Klemme" <[email protected]>
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
2007/1/8, Beermann, Albert <[email protected]>: > I want to do: > > Select * from columns where datatype like 'DA%' and default like '9999%' Assuming "default" is actually a column name (have no system to check ATM). You could try to use either "default" (i.e. with quotes) or columns.default (i.e. qualified name). Hope that helps robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[email protected]