ansaurus

Question

Answer 1

+3 A:

Use SQL LIKE syntax:

SELECT * FROM tablename WHERE name LIKE 'A%'

Jacob Relkin 2010-10-21 20:58:56

you mean LIKE 'A%'

Junior Mayhé 2010-10-21 21:00:09

@Junior, Yes. Thanks! :)

Jacob Relkin 2010-10-21 21:00:38

That query wouldn't return results that start with A, but those that end with A. so: SELECT * FROM tablename WHERE name LIKE 'A%'

james_bond 2010-10-21 21:00:39

@james_bond, I already updated my answer.

Jacob Relkin 2010-10-21 21:01:49

Yes I saw it but I hitted 'Add comment' before seeing it

james_bond 2010-10-21 22:32:56

Answer 2

+1 A:

Use a query like

SELECT `id`, `name` FROM `table` WHERE `name` LIKE :index

Then, bind :index to something like sprintf('%s%%', $selectedIndex)

It would also be a good idea to create an index on the name column.

Phil Brown 2010-10-21 21:00:31

how can i get mysql results with alphabetical pagination