var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: space in field name
I have an imported database with a field name as follows:
So because it has a space between the words, I am having troubles writing a query for it. Does anybody know the syntax to do this? I tried the following with now luck:
Bring empty set even with a Joe in the table
SELECT * FROM table WHERE 'First name' = "Joe";
SELECT * FROM table WHERE "First name" = "Joe";
Gives error in syntax...
SELECT * FROM table WHERE First name = "Joe";
Any help would be appriciated.
I suggest you remove the space in the field name (firstname) or replace the space with an underline (first_name).
space in first name
Thanks for the reply!
A good idea, but I'm not sure if I can rename it. The data is coming from a daily download from a MS SQL export to Excel with about 60 different fields. It would be extremely time comsuming to do on a daily basis. It's a pretty big database.
Is there some sort of script out ther to do this?
Re: space in field name
You need to use reverse quotes: `First Name`
SELECT * FROM table WHERE `First Name` = 'Joe';
space in field name
Ah! That did it!!!! Thanks!!