Boo-urns Posted May 2, 2008 Share Posted May 2, 2008 I was wondering what the method would be to skip certain characters in a sort by? SELECT name FROM foods WHERE viewable='Y' ORDER BY name ASC How would i skip it if the first character in the name column starts with a quote or numbers to skip to their first character? Thanks for your help! Corey Link to comment https://forums.phpfreaks.com/topic/103805-solved-skip-characters-in-sort-by/ Share on other sites More sharing options...
ucffool Posted May 2, 2008 Share Posted May 2, 2008 Could you simply just do that query and then process the results for what you want? Or is it that your query will be astronomically large with the extra items? Secondarily, if there is something unique about the entries that start with a quote or numbers, you could add an extra column to the table like 'type' and then make your WHERE class also check this 'type' category for a match as well as your viewable='Y'. Link to comment https://forums.phpfreaks.com/topic/103805-solved-skip-characters-in-sort-by/#findComment-531484 Share on other sites More sharing options...
Boo-urns Posted May 2, 2008 Author Share Posted May 2, 2008 Hmmm... The first option might work bascially what I will be doing with the data being presented is to paginate all of them and there are over 2000 rows so I don't know how quick that would be. I wasn't sure if there was a mysql function or term that I could use that I was unaware of. Link to comment https://forums.phpfreaks.com/topic/103805-solved-skip-characters-in-sort-by/#findComment-531551 Share on other sites More sharing options...
fenway Posted May 2, 2008 Share Posted May 2, 2008 Do you know which ones you want to skip? Link to comment https://forums.phpfreaks.com/topic/103805-solved-skip-characters-in-sort-by/#findComment-531670 Share on other sites More sharing options...
Boo-urns Posted May 2, 2008 Author Share Posted May 2, 2008 Any non alphabetical characters mainly so like 08 food1 skip to the f in food. or "food" skip the quotes. Link to comment https://forums.phpfreaks.com/topic/103805-solved-skip-characters-in-sort-by/#findComment-531993 Share on other sites More sharing options...
fenway Posted May 2, 2008 Share Posted May 2, 2008 Then REPLACE() the characters you don't want, and then order by that. Link to comment https://forums.phpfreaks.com/topic/103805-solved-skip-characters-in-sort-by/#findComment-532026 Share on other sites More sharing options...
Boo-urns Posted May 2, 2008 Author Share Posted May 2, 2008 Thanks fenway! Link to comment https://forums.phpfreaks.com/topic/103805-solved-skip-characters-in-sort-by/#findComment-532079 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.