I have a Database like this"
NAME - AGE
alex - 20
mathew - 14
alexandra-31
human-10
now in a text box elsewhere when i type say "al",I should get the result as alex and alexandra.
how do i do this in MySQL? please help.
-
1mySQL manual: String comparison functionsPekka– Pekka2011-09-27 10:43:44 +00:00Commented Sep 27, 2011 at 10:43
-
Thanks alot fellow developersBITS_Python– BITS_Python2011-09-27 10:49:06 +00:00Commented Sep 27, 2011 at 10:49
Add a comment
|
3 Answers
select *
from tableName
where name like 'al%'
Comments
Select name, age
From yourtable
Where name like 'al%'
Or, if you want to type any part of the name:
Select name, age
From yourtable
Where name like '%le%'
answered Sep 27, 2011 at 10:47
Adriano Carneiro
58.8k12 gold badges94 silver badges123 bronze badges
Comments
create table your_table
(NAME varchar(50),AGE int);
insert into your_table (NAME,AGE) values ('alex',20);
insert into your_table (NAME,AGE) values ('mathew',14);
insert into your_table (NAME,AGE) values ('alexandra',31);
insert into your_table (NAME,AGE) values ('human',10);
select NAME from your_table where name like 'al%';
Should do the trick...
2 Comments
Reporter
Based on your answer, I think you should complete your LIKE - statement. In my eyes use: ... like '%al%'
Tom Mac
Fair enough. I guess it depends on what the guy wants to come back in his text box. If you completed the LIKE statement with '%al%' then names such as 'hal' and 'malcolm' would come back when entering 'al' as well as 'alex' and 'alexandra' instead of just 'alex' and 'alexandra'. Thanks for the comment though!