mysql partial string search

From: uni (s0094975_at_sms.ed.ac.uk)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 09:06:40 -0000

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

Relevant Pages

  • Re: Change characters to html tags
    ... I have the following string in a MySQL Database ... Either store the correct characters in the database or run the ... Shell Scripting Recipes: ...
    (alt.html)
  • Re: SQL statement in Perl doesnt work
    ... I have written a script that reads from a MySQL database. ... That's just a string. ... It may _look_ to you like an SQL query but ... You are posting to comp.lang.perl.misc without reading the posting ...
    (comp.lang.perl.misc)
  • Re: How to handle apostrophs and semicolons
    ... unfortunately the data has not been inserted into my MySQL database because of the apostroph in the name of the street. ... At a guess, the back end PHP will be creating SQL statements using string concatenation, and putting the values from the form fields into strings delimited by apostrophes. ...
    (comp.lang.javascript)
  • Re: HOw to prevent simple View source to retrieve password
    ... Your php code isn't visible to the html end user. ... to mysql database? ... Using my browser i could easely use the function: ... IF the file includes the connection string than anyone could see my ...
    (comp.lang.php)
  • Re: Read binary data from MySQL database
    ... MySQL database. ... def showImage(self, imgstring): ... That means that imgstring is not a string, it's an array of characters. ...
    (comp.lang.python)