How do I echo only results beginning with a certain letter?
My php script is performing this query:
$query = "SELECT * FROM Race_Details WHERE Race_ID LIKE '%".$searchrace."%'";
What I would like to do is then echo results back where the column Points_ID begins with a certain letter. I have five points groupings, those beginning with Q, R, C, E and T. So, how do I filter the query results using php to only echo back records where the Points_ID begins with Q for example?
(Also, I would love to then also know how to sort these results by Points_ID - is it as simple as adding ORDER BY Points_ID to the query?)