Selecting multiple LIKE variables

[Duxie]

I'd like to allow end users to search the "title" row of my database for two text variables.

The original Code (that allowed for one variable and worked) is:
$sql = "SELECT * FROM database_table WHERE title LIKE '%$textsearch%' ORDER by title ASC ";

What I tried to do was just ADD on the second LIKE(which doesn't work) :
$sql = "SELECT * FROM database_table WHERE title LIKE '%$textsearch%' AND LIKE '%$textsearch2%' ORDER by title ASC ";

No-Go.
Any help would be much appriciated.

[tekky]

I would say you need to do....

SELECT * FROM table WHERE title LIKE '%$var%' AND title LIKE '%$var2%'

or

SELECT * FROM table WHERE title LIKE '%$var%' OR title LIKE '%$var2%'

if you are only looking for 1 or the other....

[Duxie]

Works like a charm!

Mahalo Nui Loa
(Thank you very Much)

[tekky]

not aproblem, dont forget the "mark thread resolved" link at the bottom 😉