is it necessarily to use quotes with string in where clause? can i write just “column1 = stringValue”, or it must be “column1 = ‘stringValue’”?
Thank you for your great work
is it necessarily to use quotes with string in where clause? can i write just “column1 = stringValue”, or it must be “column1 = ‘stringValue’”?
Thank you for your great work
Thank you for the answer
The semantics of “stringValue” in a query changes depending on whether you use quotes or not. For example, suppose you have a property (and corresponding column) “name”. The following two scenarios are possible:
name = ‘Bob’
name = Bob
In the first case, we check if the column/property “name” contains value ‘Bob’. In the second case, we check if the value of property/column “name” equals the value of the property/column “Bob”. So in this case, “Bob” would be referencing a column/property rather than a literal value.
Hope this helps.
Regards,Mark
Some useful info or possibly even a guide you will find here. So I recommend that you check out this blog as soon as you can