Select a row containing a string in a mysql column

Question

I am trying to select all rows which contains string $places in a colum ADDRESS. here is what I coded but it only works when a cell only contains that string if there is other characters it wouldn't work

$sql = "SELECT *,CONCAT(mapLan,',',mapLon) as LatitudeLongitude FROM " . $table . " where ADDRESS like '$places' and SIZE between $firstrange and $secondrange";

For example $places = "East London" It would only select the row in which a cell only store East London and would leave alone the cells with Old Street, East London

What I want is to select all those rows which contains East London in Column ADDRESS

You have to supply an example for your rows and show which you are want to be returned and what do you don't to get them. — SaidbakR
– SaidbakR, Commented Feb 4, 2015 at 15:24
@sємsєм I want it to return only those rows containing the full string stored in $places for example if it's East London it shouldn't show rows with only East and London but with full phrase East London - Thanks — Muhammad
– Muhammad, Commented Feb 4, 2015 at 15:33
if $places is East London, the answer I gave you will never return rows that only contain East or London — dsharew
– dsharew, Commented Feb 4, 2015 at 15:36
Do not create hypothetical examples if you are having any problem just post the real data, I am sure you will get help. — dsharew
– dsharew, Commented Feb 4, 2015 at 15:51

dsharew · Accepted Answer · 2015-02-04 15:20:27Z

3

You forget to use the % wildcard.

meaning:
% Matches any number of characters, even zero characters

$sql = "SELECT *,CONCAT(mapLan,',',mapLon) as LatitudeLongitude FROM " . $table . " where ADDRESS like '%$places%' and SIZE between $firstrange and $secondrange";

visit this link for detail

edited Feb 4, 2015 at 15:20

answered Feb 4, 2015 at 15:13

dsharew

10.7k6 gold badges55 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Muhammad Over a year ago

I have already tried this but it also select the other rows that doesn't exactly contain the required string I just want those rows which contains the exact string stored in $places

SaidbakR Over a year ago

@Muhammad No way, I think that %East London% should return any row contains East London.

dsharew Over a year ago

no, it will not return row that do not contain $places

Prerak Sola Over a year ago

That is not possible. If $places = "east london" than it will only return the rows containing "east london". Check this demo here: sqlfiddle.com/#!2/c31ae/1

SaidbakR Over a year ago

i.e It will not return East Paris

|

Collectives™ on Stack Overflow

Select a row containing a string in a mysql column

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related