27 Oct 2009 at 15:26 #1 PMWD PMWD Associate Joined 8 Aug 2008 Posts 302 Is it possible to get MySQL and PHP to basically say "SELECT * FROM table WHERE firstletter of title='$letter'" ?
Is it possible to get MySQL and PHP to basically say "SELECT * FROM table WHERE firstletter of title='$letter'" ?
27 Oct 2009 at 15:28 #3 PMWD PMWD Associate OP Joined 8 Aug 2008 Posts 302 Ahh genius I'll try that, thanks PiKe
27 Oct 2009 at 15:29 #4 PMWD PMWD Associate OP Joined 8 Aug 2008 Posts 302 Oh another one, say I wanted to find everything that started with a numeric?
27 Oct 2009 at 15:36 #6 PMWD PMWD Associate OP Joined 8 Aug 2008 Posts 302 So that'll pull any number so if it's "3.1 update" it'll work? Is there any way of doing it so that it pulls anything that's not a letter of the alphabet instead? Just in case we gets brackets etc?
So that'll pull any number so if it's "3.1 update" it'll work? Is there any way of doing it so that it pulls anything that's not a letter of the alphabet instead? Just in case we gets brackets etc?
27 Oct 2009 at 15:51 #8 PMWD PMWD Associate OP Joined 8 Aug 2008 Posts 302 Ahh right so I'd need to spool through 0-9? No probs.
1 Nov 2009 at 15:09 #11 PMWD PMWD Associate OP Joined 8 Aug 2008 Posts 302 Cheers fella, ended up using PHP: REGEXP '^[[:digit:]]'
