mysql alphabetical order

Question

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

User · Answer

I try to sort data with query it working fine for me please try this:

select name from user order by name asc

Also try below query for search record by alphabetically

SELECT name  FROM `user` WHERE `name` LIKE 'b%'

User · Answer

You can use   SELECT name FROM user WHERE name like  b   ORDER BY name

User · Answer

MySQL solution  select Name from Employee order by Name    Order by will order the names from a to z

User · Answer

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

User · Answer

i want to show records only starting with b   select name from user where name LIKE  b         i am trying to sort MySQL data alphabeticaly   select name from user ORDER BY name       i am trying to sort MySQL data in reverse alphabetic order   select name from user ORDER BY name desc

User · Answer

You do not need to user where clause while ordering the data alphabetically  here is my code  SELECT   FROM tbl name ORDER BY field name   that s it  It return the data in alphabetical order ie  From A to Z

User · Answer

Wildcard Characters are used with like clause to sort records   if we want to search a string which is starts with B then code is like the following   select   from tablename where colname like  B   order by columnname    if we want to search a string which is ends with B then code is like the following  select   from tablename where colname like   B  order by columnname    if we want to search a string which is contains B then code is like the following  select   from tablename where colname like   B   order by columnname    if we want to search a string in which second character is B then code is like the following  select   from tablename where colname like   B   order by columnname    if we want to search a string in which third character is B then code is like the following  select   from tablename where colname like    B   order by columnname    note   one underscore for one character

User · Answer

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

[mysql] mysql alphabetical order

Examples related to mysql