I am writing this by hand, and is being used within Coldfusion. MySql is v 4.1.7 and I am connecting via ODBC.
Steve <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Your sample query is not valid SQL. What tool/language are you using to > run this query? There must be something interpreting what you entered and > mis-representing your query to the MySQL server. Without that piece of the > puzzle I am completely in the dark. > > It would also help to know what version MySQL server you are using and if > you are connecting to your MySQL server through any kind of library > (connector/J, ODBC, etc.) which one and what version is it? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > Steve Grosz <[EMAIL PROTECTED]> wrote on 12/03/2004 12:58:30 PM: > > > I am kinda new to SQL, and am having a problem trying to get something > done. > > > > I'm trying to search for usernames in one of my tables. The name is > > stored as firstname lastname. > > > > I wrote my query as > > select Cust_ID, Cust_Name > > from mailings > > where ucase(Name) = ucase(Cust_Name) > > > > When it runs, I get a error: > > You have an error in your SQL syntax; check the manual that corresponds > > to your MySQL server version for the right syntax to use near 'Grosz = > > Cust_Name' at line 3 > > > > It seems that its only searching for the name after the space between > > the first and last name. > > > > How can I correct this in the query? > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]