mysql alphabetical order

Question

hi

i am trying to sort mysql data with alphabeticaly like

A | B | C | D

when i click on B this query runs

select name from user order by 'b'

but result showing all records starting with a or c or d i want to show records only starting with b

thanks for help

Answer 1

but result showing all records starting with a or c or d i want to show records only starting with b

You should use WHERE in that case:

select name from user where name = 'b' order by name

If you want to allow regex, you can use the LIKE operator there too if you want. Example:

select name from user where name like 'b%' order by name

That will select records starting with b. Following query on the other hand will select all rows where b is found anywhere in the column:

select name from user where name like '%b%' order by name

Answer 2

If you want to restrict the rows that are returned by a query, you need to use a WHERE clause, rather than an ORDER BY clause. Try

select name from user where name like 'b%'

Answer 3

i want to show records only starting with b

select name from user where fieldName LIKE 'b%'

i am trying to sort mysql data with alphabeticaly

select name from user where fieldName ORDER BY name

Answer 4

You can use:

SELECT name FROM user WHERE name like 'b%' ORDER BY name