August 6th, 2007, 11:29 AM
Thanks for taking the time to read my question.
I'm new to MySQL (I've got all my books in front of me) and I'm trying to select all records frm tblRoster where 'Team' is LIKE 'Coyotes'
I can't seem to get it to work
If I use PHPMyAdmin and use the Search tab, it make a query that looks like this
Why does it add all that extra stuff? Do I have the wrong Collation on the field? I was told I should use this. Should I use a different one? I don't want to have to do the CONVERT every time I make a query.
August 6th, 2007, 11:36 AM
'Team' -- this is a string
`Team` -- this is a valid delimited identifier, but the identifier delimiters are not required
Team -- this is a valid identifier, and is what you should be using
ignore that other stuff phpmyadmin creates -- it's one of the worst tools around for producing useful sql
August 6th, 2007, 12:08 PM
So then taking that what am I doing wrong here?
August 6th, 2007, 12:19 PM
what is wrong is that the INSERT statement does not permit a WHERE clause
August 6th, 2007, 02:34 PM
Sorry for my slow reply. I had to step away for a bit.
I've been looking around but haven't found anything yet.... how do you update only specific records.... oh... I just answered my own question.
You know, some days I wonder how I get dressed in the morning.
Thanks for your help.
August 6th, 2007, 02:47 PM
reminds me of icanhascheezburger.com
I'M IN UR CLOSET...
... STEALIN' UR CLOZE