mysql : how can i select username starting with B to the last name ? - PHPBuilder Forums

mysql : how can i select username starting with B to the last name ?

nodi

hello gays

is that any way to display a list of names starting from Bxxxx or Cxxxx or Dxxxxx to Zxxxxx ?

please advice

jubripley

SELECT * FROM your_table WHERE LEFT(name_field, 1) BETWEEN 'A' AND 'B' OR LEFT(name_field, 1) BETWEEN 'D' AND 'Z'

cgraz

% is a wildcard, so....

SELECT * FROM table WHERE field_name LIKE 'B%'

Where B is the first letter.

Cgraz

jubripley

yeah, but "B%" doesn't give him names starting with B through D. That's what I thought he was asking.