CODEWITHSUNDEEP
phpmysql
rabotalius
rabotalius

Reputation: 1568

Mysql or condition

How to properly use or in mysql query?

With the following query I'm trying to search for string in playlist_name and name, but it's ignoring the "playlist_name"

$search_results = mysql_query("SELECT * FROM show where playlist_name or name LIKE '%$search_string%'");

Upvotes: 0

Views: 66

Answers (3)

Ranjith
Ranjith

Reputation: 2819

Check condition for both fields.

where playlist_name LIKE '%$search_string%'" OR name LIKE '%$search_string%'"

Upvotes: 1

Mr. Alien
Mr. Alien

Reputation: 157334

You need to use LIKE for the first condition too

$search_results = mysql_query("SELECT * FROM show WHERE
playlist_name LIKE '%$search_string%' 
OR
name LIKE '%$search_string%'");

Upvotes: 1

David
David

Reputation: 4117

where playlist_name LIKE '%$search_string%' or name LIKE '%$search_string%'

Upvotes: 1

Related Questions