MySQL SELECT with multiple where conditions
MySQL SELECT with multiple where conditions
I 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'
[/quote:09cf04e097]
Tags:
mysql, select, multiple, conditionsmysql, conditionsi, rows, apparent, cf,