i have a table like
when i do a simple 'LIKE %s%' search for row cat for letter 's'..
i get all the rows that contain letter 's' in order of their id..
so the result is:
but if i type 's' the words starting with 's' must come first, coz more chances are that i am looking for a word with that begins with 's', this is common sense.. so the intended result should be something like
where words starting with 's' appear first and then the words containing 's'
i did a lot of searching but couldn't find anything helpful.. i really hope someone out there could help..
i simply want to know how to order search by the character searched for..
i hope this makes sense :)