[Subject Prev][Subject Next][Thread Prev][Thread Next][Subject Index][Thread Index]

Re: How to search a mysql db

----- Original Message -----
From: "Goldwyn" <goldwyn_r@xxxxxxxxxxxx>
> I am trying to search a search string which could be a sub-string of a
> record's field value.
> eg  my database contains 2 fields(only) - full name and full address.
> I want to search the database by first name or by city which is just a
> of the fields full name and full address.

Till you get a better answer; I am not an SQL programmer:

select * from table where address like '%elhi%'

will find Delhi, New Delhi, delhi, etc

% matches like a * in shell glob.