php MySQL multiple words search

Question

This is the music. table It contains artists and titles. Artists are separated by commas if more than one artist sing a song. I want to set up a search function so users can search for one artist, both artists, no artists and title etc.

Table music:

|      artist     |    title   |
|------------------------------|
|eminem,lil wayne |   no love  |
|kida             |   o'najr   |

User may search like this:

eminem no love
lil wayne no love
no love eminem
no love lil wayne

Also user can or can not type special chars like ' if user search:

kida onajr
kida o najr
kida o'najr

the result should be the same.

This is my code up to now:

$search_value = "...";
$query = "select * from `music` where `title` like '%$search_value%' or `artist` like '%$search_value%'";

But if I search lil wayne no love no results are shown.

How does this differ from your other question?

Funk Forty Niner
– Funk Forty Niner

2014-09-23 21:05:26 +00:00
Commented Sep 23, 2014 at 21:05 — Funk Forty Niner
– Funk Forty Niner, Commented Sep 23, 2014 at 21:05
Check out this stackoverflow.com/questions/759580/…

Mihai Varga
– Mihai Varga

2014-09-23 21:08:10 +00:00
Commented Sep 23, 2014 at 21:08 — Mihai Varga
– Mihai Varga, Commented Sep 23, 2014 at 21:08
It has nothing to do with multiple words search. @Fred-ii-

M1X
– M1X

2014-09-23 21:11:06 +00:00
Commented Sep 23, 2014 at 21:11 — M1X
– M1X, Commented Sep 23, 2014 at 21:11

Zerquix18 · Accepted Answer · 2014-09-23 21:06:37Z

2

You should use MATCH AGAINST for those kinda search.

answered Sep 23, 2014 at 21:06

Zerquix18

7346 silver badges19 bronze badges

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

3 Comments

M1X Over a year ago

Like this? select * from music match(title, artist) against ('%$search_value%') This is giving me an error.

VMai Over a year ago

You've got to break your search values into single ones. That's not your LIKE pattern.

Zerquix18 Over a year ago

@rexhn You have to add FULLTEXT(title,artist) in your table, you have to remake it or do an ALTER TABLE. Read the documentation.

Collectives™ on Stack Overflow

php MySQL multiple words search

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related