[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.