Closed Thread Icon

Topic awaiting preservation: Select column using first letter. Pages that link to <a href="https://ozoneasylum.com/backlink?for=12101" title="Pages that link to Topic awaiting preservation: Select column using first letter." rel="nofollow" >Topic awaiting preservation: Select column using first letter.\

 
Author Thread
Carnage
Nervous Wreck (II) Inmate

From:
Insane since: May 2001

posted posted 03-10-2002 16:24

I'm trying to only select the rows from a table where the first column called "name" is only of a letter.

So basically if I pass page.php?name=a

I get every listing that starts with the letter a. And if I pass b instead I get that. I know how to filter the query to limit it that way, but I really want to limit the query so I only pull what I want to optimize database access.

butcher
Paranoid (IV) Inmate

From: New Jersey, USA
Insane since: Oct 2000

posted posted 03-10-2002 18:57

How else do you want to filter it, you didn't say?

If you just want to limit the amount you get back just use

LIMIT 5;

or what ever amount you want returned from you query.

-Butcher-

« BackwardsOnwards »

Show Forum Drop Down Menu