SQL LIKE partial match from string

Question

I need do searching from longer string. In sql in locality is 'London' and i need use LIKE and string of more cities how in example.. This doesnt work. Please help me, thanks

$result = mysqli_query($con, "SELECT * FROM automoto WHERE (title LIKE '%$keyword%') AND locality LIKE '%London%Paris%' ");

Use OR: (title LIKE '%$keyword%') AND (locality LIKE '%London%' OR locality LIKE '%Paris%') — dognose
– dognose, Commented Jul 16, 2014 at 21:33
This is pretty standard practice here. You may find you need to loop your words in PHP to assemble the query string too. — scrowler
– scrowler, Commented Jul 16, 2014 at 21:35
Thanks, and any nicer solution? Isnt possible to rewrite %London%Paris% to working shape? — user3780933
– user3780933, Commented Jul 16, 2014 at 21:41

dognose · Accepted Answer · 2014-07-16 21:36:47Z

2

The most reliable way would be to use one OR per city:

(title LIKE '%$keyword%') AND (locality LIKE '%London%' OR locality LIKE '%Paris%')

if you do not want to build up all these "or"-conditions, you could use a regex to match:

(title LIKE '%$keyword%') AND locality REGEXP '(London|Paris)'

answered Jul 16, 2014 at 21:36

dognose

21k9 gold badges67 silver badges108 bronze badges

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

1 Comment

bdutta74 Over a year ago

Have read that REGEXP searches can take arbitrary time and memory space. If that is indeed true, in spite of it's elegance (& legibility), the former may be preferred.

Action Dan · Accepted Answer · 2014-07-16 21:34:48Z

0

Build up a string containing each city in an OR:

SELECT * FROM automoto WHERE title LIKE '%$keyword%' AND (locality LIKE '%London%' OR  locality LIKE '%Paris%')

answered Jul 16, 2014 at 21:34

Action Dan

4334 silver badges10 bronze badges

Collectives™ on Stack Overflow

SQL LIKE partial match from string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related