Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / February 2004

Tip: Looking for answers? Try searching our database.

mysql partial string search

Thread view: 
uni - 25 Feb 2004 09:06 GMT
hello,

I was wondering if it is possible to search a mysql database by partial
strings, like say i have a name column with scotland, and i give this
string,
select * from table where name='co';
are there any signs like in linux you can say *co* to the anywhere in the
string...

Thanks

Erik
Christophe Vanfleteren - 25 Feb 2004 09:14 GMT
> hello,
>
[quoted text clipped - 4 lines]
> are there any signs like in linux you can say *co* to the anywhere in the
> string...

Try
select * from table where name like '%co%'

Signature

Kind regards,
Christophe Vanfleteren

uni - 25 Feb 2004 09:16 GMT
thanks,

> > hello,
> >
[quoted text clipped - 7 lines]
> Try
> select * from table where name like '%co%'


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.