hi,
can someone help me out wih these 2 problems.
1. how can i select the last n number of rows in a table? i do not know what the data in those rows may be. i need to display whatever is present in these rows.
can someonre tell me how is this possible in mysql?
2. i want to write a query such that if an user enters two words A and B, the results from the search should be such that A or B is present but not (A and B).
ie either of them but not both in the string
how do i write the sql for this?
thanks for any help
steve
can someone help me out wih these 2 problems.
1. how can i select the last n number of rows in a table? i do not know what the data in those rows may be. i need to display whatever is present in these rows.
can someonre tell me how is this possible in mysql?
2. i want to write a query such that if an user enters two words A and B, the results from the search should be such that A or B is present but not (A and B).
ie either of them but not both in the string
how do i write the sql for this?
thanks for any help
steve