MySQL SELECT with multiple where conditionsI can get a match on rows for now apparent reason
[quote:09cf04e097]SELECT * FROM TABLE WHERE field = 'value' & value = 'field'
[/quote:09cf04e097]
To make it work as expected use 'AND' instead of '&' they seem to have a completely different and unexpected effect.
[quote:09cf04e097]SELECT * FROM TABLE WHERE field = 'value' AND value = 'field'
[........