is there any mysql query that finds a value between two column values
e,g;
i have a value of [B]5.00[/B] and there are two columns of table as [B]from[/B] and [B]to[/B], now i want to search that row id from table where value [B]5.00[/B] exists
<i> </i>SELECT * FROM table WHERE from <= 5 AND to >= 5
Help @mahfooz spread the word by sharing this article on Twitter...