Log in

View Full Version : How to search data from A until C ?



jkdevil
09-13-2008, 05:12 PM
Sorry if so many errors in grammar.
I am new in MySQL so I have a problem in searching data from MySQL.
I want to know how to search data if I want to search data from A until C ?
I have used 'LIKE' but it just showing data which have A and C in the front,inside and behind the word.
Please, help me. Thank you.

djr33
09-14-2008, 04:42 PM
One way to do this is to just do 3 searches, one for A, one for B, and one for C.
You could look into OR statements in MySQL, also. (LIKE A OR LIKE B OR LIKE C). But I'm not sure how that works.