I am trying to do something like this in a mysql database:
SELECT key_ID FROM table WHERE key="test1" AND "test2"
This from a table with:
key_id key
1 test2
2 test1
3 test3
4 test4
should give the result:
2
1
This obviously doesn't work...how to change it so it does (it should realy be something like this because in the next ""turn" the selectstatement goes like: .. WHERE key = "test1" AND "test2" AND "test3"
Any ideas?
Thx m8
SELECT key_ID FROM table WHERE key="test1" AND "test2"
This from a table with:
key_id key
1 test2
2 test1
3 test3
4 test4
should give the result:
2
1
This obviously doesn't work...how to change it so it does (it should realy be something like this because in the next ""turn" the selectstatement goes like: .. WHERE key = "test1" AND "test2" AND "test3"
Any ideas?
Thx m8