Re: [PHP] index search

2008-10-24 Thread Ryan S
Are you sure LIKE isn't working? I would think LIKE "a%" would work. For 0-9, I would think you can use <= 9 or you can use BETWEEN 0 and 9. Silly me, the reason it was not working was I am so used to %something% and used that instead of something% Anyway, it was a not a useless post for me

Re: [PHP] index search

2008-10-24 Thread Andrew Ballard
On Fri, Oct 24, 2008 at 11:08 AM, Robert Cummings <[EMAIL PROTECTED]> wrote: > On Fri, 2008-10-24 at 10:49 -0400, Andrew Ballard wrote: >> On Fri, Oct 24, 2008 at 10:22 AM, Robert Cummings <[EMAIL PROTECTED]> wrote: >> >> As for the numeric comparison, I know MySQL has a REGEXP comparison >> >> sim

Re: [PHP] index search

2008-10-24 Thread Robert Cummings
On Fri, 2008-10-24 at 10:49 -0400, Andrew Ballard wrote: > On Fri, Oct 24, 2008 at 10:22 AM, Robert Cummings <[EMAIL PROTECTED]> wrote: > >> As for the numeric comparison, I know MySQL has a REGEXP comparison > >> similar to the LIKE comparator, but I don't know enough about MySQL to > >> know if i

Re: [PHP] index search

2008-10-24 Thread Andrew Ballard
On Fri, Oct 24, 2008 at 10:22 AM, Robert Cummings <[EMAIL PROTECTED]> wrote: >> As for the numeric comparison, I know MySQL has a REGEXP comparison >> similar to the LIKE comparator, but I don't know enough about MySQL to >> know if it can similarly benefit from indexes the same way. (SQL >> Server

Re: [PHP] index search

2008-10-24 Thread Robert Cummings
On Fri, 2008-10-24 at 10:20 -0400, Andrew Ballard wrote: > On Thu, Oct 23, 2008 at 10:49 PM, Robert Cummings <[EMAIL PROTECTED]> wrote: > > On Thu, 2008-10-23 at 19:30 -0700, Ryan S wrote: > >> Hey all, > >> Was wondering how this is done, have a bunch of links like so: > >> 0-9 : a : b : c ->

Re: [PHP] index search

2008-10-24 Thread Andrew Ballard
On Thu, Oct 23, 2008 at 10:49 PM, Robert Cummings <[EMAIL PROTECTED]> wrote: > On Thu, 2008-10-23 at 19:30 -0700, Ryan S wrote: >> Hey all, >> Was wondering how this is done, have a bunch of links like so: >> 0-9 : a : b : c -> till Z >> >> these will be linked to the program (so far have done

Re: [PHP] index search

2008-10-23 Thread Robert Cummings
On Thu, 2008-10-23 at 19:30 -0700, Ryan S wrote: > Hey all, > Was wondering how this is done, have a bunch of links like so: > 0-9 : a : b : c -> till Z > > these will be linked to the program (so far have done this) but when the user > clicks any of those links I want to query the DB for jus

[PHP] index search

2008-10-23 Thread Ryan S
Hey all, Was wondering how this is done, have a bunch of links like so: 0-9 : a : b : c -> till Z these will be linked to the program (so far have done this) but when the user clicks any of those links I want to query the DB for just the first alphabet from the field "title", using LIKE is n